How to show value in percentage format

[mahitham]

Hi Experts,

Can any one please help me to show the value in percentage format 

My expression is

(Sum(Sales)/Sum(Products))*100

I am getting results like 20,30,40.. I have to show these values in 20%,30%,40% in expression editor using num format instead of default number formats.

I have tried like below

Num((Sum(Sales)/Sum(Products))*100,'#,##0%') but its not working.

Please help me on this.

Thanks in advance.

[Mauritz_SA · Accepted solution]

Hi Mahitham

You are multiplying the fraction by 100 and then formatting it as a percentage (which multiplies it by 100 and add the % in the UI). Try Num((Sum(Sales)/Sum(Products)),'#0%').

Good luck.

Mauritz

[Channa]

just remove *100

in number format set as %