Pivot table > calculated fields

New Contributor

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_0-1659101202125.png

HelloCathy_0-1659102281384.png

HelloCathy_0-1659102340561.png

 

 

 

4 Replies

@HelloCathy Obviously, when 0% is incorrect then the formula is incorrect. Would be helpful if you could share a file (Ondrive, Google docs or similar) or at least some screenshots of a larger part of the pivot table, the formula used and the underlying data.

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'



I've attached the screenshot of the pivot

@HelloCathy That formula does not take the count of transfers divided by the count of handles. It takes the total of all transferred divided by the total handled. Difficult to explain. Would need the data to demonstrate without guessing.