Number formatting in %

[#1]

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 ?

[vikasmahajan]

Select number tab  fix 2 decimal  and multiply formula by *100 and  select Show in % setting

Hope this will resolve your problem

Vikas

[Sokkorn · Accepted solution]

Hi sairan06,

=Num(0.0241,'#,##0.00%') Return 2.41%

Apply to your expression, we should not multiply by 100.

Regards,

Sokkorn

[er_mohit]

Try this

Num((Sum(Online_Sales)/(Sum(Online_Sales)+ Sum(Retail_Sales))),#,##0.00%)