Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
just remove *100
in number format set as %