Forum Discussion
HelloCathy
Jul 29, 2022Copper Contributor
Pivot table > calculated fields
Any one knows why 1 field is showing zero in Pivot? formula in calculated fields are correct. all columns showing data correctly except 1 column
HelloCathy
Jul 29, 2022Copper Contributor
The formula is correct. I cant share the whole data but I can give you some parts.
This is the formula for the missing data 31 Transfer% ='Contacts transferred out'/'Contacts handled'
This is the formula for the missing data 31 Transfer% ='Contacts transferred out'/'Contacts handled'