Jul 29 2022 06:23 AM - edited Jul 29 2022 06:45 AM
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
Jul 29 2022 06:36 AM
@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.
Jul 29 2022 06:44 AM
Jul 29 2022 06:46 AM
Jul 29 2022 09:26 AM
@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.