Selection based Percentage format

[rathnam_qv]

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.

[Anonymous]

Try this

If(String='GP%', (Value1-Value2) /Value1)

and in Formatting->simple->keep in percentage

[YoussefBelloum]

Hi,

you are maybe ovveriding the format on the Number section.

[rathnam_qv]

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.

[rathnam_qv]

Hi Youssef,

I kept format as AUTO.

Thanks,

Rathnam.

[Anonymous]

Try with number formatting->measure expression

[rathnam_qv]

Number format will apply to both the selections...i want to apply it only for GP% selection.