topic Re: Selection based Percentage format in App Development

Selection based Percentage format

rathnam_qv — Thu, 14 Dec 2017 09:11:03 GMT

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 — Thu, 14 Dec 2017 09:27:53 GMT

Try this

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

and in Formatting->simple->keep in percentage

YoussefBelloum — Thu, 14 Dec 2017 09:36:47 GMT

Hi,

you are maybe ovveriding the format on the Number section.

rathnam_qv — Thu, 14 Dec 2017 10:39:20 GMT

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 — Thu, 14 Dec 2017 10:40:13 GMT

Hi Youssef,

I kept format as AUTO.

Thanks,

Rathnam.

Anonymous — Thu, 14 Dec 2017 10:42:13 GMT

Try with number formatting->measure expression

rathnam_qv — Fri, 15 Dec 2017 03:23:02 GMT

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