Issue with Percentage in Pivot Table
Summary
Issue with Summarizing Percentages in Pivot TablesContent
I have a calculation for the fill rate based upon hired vs target. This is working fine in the details, but when I summarize it in a pivot table the numbers are flat out wrong. Ideas on how to fix?
formula: ((("Candidate Counts"."# Submissions Currently Hired")*1.0)/((CAST("Requisition Flex Fields"."UDF25" AS INTEGER))*1.0))*100
This formula works correctly in the details table, but the pivot table isn't calculating correctly.
Images attached
Tagged:
0