Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Issue with Percentage in Pivot Table
Ellen Manthei
Rank 2 - Community Beginner
Summary
Issue with Summarizing Percentages in Pivot Tables
Content
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