Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am show GP and GP% based on selection.
Issue is while selection GP%...value is displaying like 6.32 but i want to display it as 6.32%.
My expression is If(String='GP%', Num( (Value1-Value2) /Value1,'0.00%')
Need your suggestions.
Thanks,
Rathnam.
Try this
If(String='GP%', (Value1-Value2) /Value1)
and in Formatting->simple->keep in percentage
Hi,
you are maybe ovveriding the format on the Number section.
Hi Aparna,
i am calling two conditions in the same expression,
IF(String='GP$',Num(condtion1,'#,##0'),
If(String='GP%', Num( (Value1-Value2) /Value1,'0.00%'))
Kept Format is "AUTO"
GP$ format is working fine. only issue with GP% format.
Thanks,
Rathnam.
Hi Youssef,
I kept format as AUTO.
Thanks,
Rathnam.
Try with number formatting->measure expression
Number format will apply to both the selections...i want to apply it only for GP% selection.