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

Question

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 · Answer

Hi @User_HQ9TE

Please, check your aggregation rule. I tested this and it working as expected.

Regards,

Ezequiel.

Jorge Olmeda · Answer

Hi @User_HQ9TE try this formula SUM( BY /SUM( BY . It should work. Regards, Jorge

EzequielC-Oracle · Answer

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.