Solved: Number formatting in % - Qlik Community

Report Inappropriate Content · ‎2013-06-04

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 ?

Sokkorn · ‎2013-06-04

Hi sairan06,

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

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

Regards,

Sokkorn

View solution in original post

vikasmahajan · ‎2013-06-04

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

Hope this will resolve your problem

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Sokkorn · ‎2013-06-04

Hi sairan06,

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

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

Regards,

Sokkorn

er_mohit · ‎2013-06-04

Try this

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

Number formatting in %

Related Topics