General OBIEE

Get Involved. Join the Conversation.

Topic

    Ellen Manthei
    Issue with Percentage in Pivot Table
    Topic posted February 23, 2017 by Ellen MantheiSilver Trophy: 7,500+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI, Report Layouts, Report Output, Reports, Taleo Enterprise 
    62 Views
    Title:
    Issue with Percentage in Pivot Table
    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

     

    Document: