Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Average assignment count sum

Accepted answer
11
Views
1
Comments
Lauriane Massin Whitaker
Lauriane Massin Whitaker Rank 5 - Community Champion
in Oracle Fusion HCM Analytics

Hi,

I've had to calculate the AVG headcount assignment by male and female and worker category on the report below entitled "Effectif Moyen" (highlighted). The figures are right.

But in the total line, it seems like the average of the 2 lines above is displayed…. This is not what I was expected when I added the sum parameter.

Instead of having 2,50 and 33,88 displayed, I was exepected the sum of 2,17-2,83 = 5 and 27,75+40 = 67,75

image.png

Does anyone know how to do ?

Thank you very much.

Regards,

Lauriane

Best Answer

  • Rajesh L-Oracle
    Rajesh L-Oracle Mod
    Answer ✓

    Hi Laurine,

    Thank you for asking your question in the Oracle Analytics Community.

    Please try using ifnull on each of the measures, so all relevant entries at dimensional columns are considered and so in grand total as well.

    If above suggestion does not help can you please log a SR with your .dva file so that support can further test and provide suggestion on this.

    thank you