Oracle Analytics and AI

Lauriane Massin Whitaker

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

Does anyone know how to do ?

Thank you very much.

Regards,

Lauriane

Rajesh L-Oracle

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