Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

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 6 - Analytics & AI Lead
edited Jan 16, 2026 7:59AM in Oracle Fusion AI Data Platform Forum

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

Tagged:

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