Oracle Transactional Business Intelligence

Products Banner

Issue with Percentage in Pivot Table

12
Views
0
Comments

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