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.
If(String='GP%', (Value1-Value2) /Value1)
and in Formatting->simple->keep in percentage
i am calling two conditions in the same expression,
If(String='GP%', Num( (Value1-Value2) /Value1,'0.00%'))
Kept Format is "AUTO"
GP$ format is working fine. only issue with GP% format.
Try with number formatting->measure expression
Number format will apply to both the selections...i want to apply it only for GP% selection.
you are maybe ovveriding the format on the Number section.
I kept format as AUTO.
Retrieving data ...