Categories
- All Categories
- 166 Oracle Analytics News
- 33 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
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