Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- 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