If applied formula in column grand total percentage value doesn't correct percentage

User_HQ9TE · Mar 13, 2024 5:59PM

If applied formula in column grand total percentage

But column value based on formula is correct but grand total percentage is not correct

2/804 *100=0.25% is correct

But 29/136785 *100=0.49% is not correct 0.02% is correct.

How to set grand total percentage in report.

Please help me anyone

IMG_20240313_225653.jpg

EzequielC-Oracle · Mar 13, 2024 8:25PM

Hi @User_HQ9TE

I tested this and it is working as expected. Please, edit the view and check your aggregation rule for the measure. Set it to the Default rule and test.

Regards,

Ezequiel.

User_HQ9TE · Mar 14, 2024 6:46PM

https://community.oracle.com/products/oracleanalytics/discussion/comment/52724#Comment_52724

I did as you said tried but still getting same issue. Couldn't change.

Could you please help me.

Thanks

EzequielC-Oracle · Mar 14, 2024 8:06PM

Hi,

Please, can you provide more details on how you build your column and the grand total?

Provide screenshots showing the column formula in the Edit Column Formula box and the current aggregation rule and Grand Total in the Edit View box.

Did you edit the column formula to add your calculation? Is it calculated in the data source?

Also, check the aggregation rule in the Edit Column Formula box.

Regards,

Ezequiel.

Jorge Olmeda · Mar 15, 2024 1:57PM

Hi @User_HQ9TE try this formula SUM(<your numerator fact> BY <all dimensions in the view separated by commas>/SUM(<your denominator fact> BY <all dimensions in the view separated by commas>. It should work.

Regards,

Jorge