Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am displaying a text object as follows
=Num(((Sum(Online_Sales)/(Sum(Online_Sales)+ Sum(Retail_Sales)))*100),#,##0.00%)
If I manually calculate the values should be in Single digit. approx 2.41%. I am getting 241.48%.
Should I multiply by 100 ?
Hi sairan06,
=Num(0.0241,'#,##0.00%') Return 2.41%
Apply to your expression, we should not multiply by 100.
Regards,
Sokkorn
Select number tab fix 2 decimal and multiply formula by *100 and select Show in % setting
Hope this will resolve your problem
Vikas
Hi sairan06,
=Num(0.0241,'#,##0.00%') Return 2.41%
Apply to your expression, we should not multiply by 100.
Regards,
Sokkorn
Try this
Num((Sum(Online_Sales)/(Sum(Online_Sales)+ Sum(Retail_Sales))),#,##0.00%)