topic How to add a percentage symbol post expression in App Development

How to add a percentage symbol post expression

Kaushik2020 — Wed, 26 Jul 2023 09:36:09 GMT

HI all, below expression provides a value. I want to show a percentage symbol once the IF condition is true.

below is my expression:

if((if(Units='%',Num(Sum([Jun-2023]/100),'##.00') ,Num(Sum([Jun-2023]),'##.00'))) > 1000000,
num((if(Units='%',Num(Sum([Jun-2023]/100),'##.00') ,Num(Sum([Jun-2023]),'##.00')))/1000000, '#.##0,##M', ',', '.'),
if((if(Units='%',Num(Sum([Jun-2023]/100),'##.00') ,Num(Sum([Jun-2023]),'##.00'))) > 1000,
num((if(Units='%',Num(Sum([Jun-2023]/100),'##.00') ,Num(Sum([Jun-2023]),'##.00')))/1000, '#.##0,##K', ',', '.'),
num((if(Units='%',Num(Sum([Jun-2023]/100),'##.00') ,Num(Sum([Jun-2023]),'##.00'))), '#.##0,##', ',', '.')))

when I concatenate a percentage symbol post the IF true block, there is a change in the values which it display. pls see image for more info.

Please suggest.

Re: How to add a percentage symbol post expression

Mark_Little — Wed, 26 Jul 2023 09:44:41 GMT

u need to add it to your num() function. something like below

'#,##0.0%;(#,##0.0)%;-'

Also ensure the measure Number Formatting is set to Measure expression.

Re: How to add a percentage symbol post expression

Kaushik2020 — Wed, 26 Jul 2023 11:20:52 GMT

Thanks for the swift reply. I changed to below way. let me know if I am in sync with your suggestion. Still I cannot see percentage symbol. let me know if I am missing anything.

if((if(Units='%',Num(Sum([Jun-2023]/100),'#,##0.0%;(#,##0.0)%;-') ,Num(Sum([Jun-2023]),'##.00'))) > 1000000,
num((if(Units='%',Num(Sum([Jun-2023]/100),'#,##0.0%;(#,##0.0)%;-') ,Num(Sum([Jun-2023]),'##.00')))/1000000, '#.##0,##M', ',', '.'),
if((if(Units='%',Num(Sum([Jun-2023]/100),'#,##0.0%;(#,##0.0)%;-') ,Num(Sum([Jun-2023]),'##.00'))) > 1000,
num((if(Units='%',Num(Sum([Jun-2023]/100),'#,##0.0%;(#,##0.0)%;-') ,Num(Sum([Jun-2023]),'##.00')))/1000, '#.##0,##K', ',', '.'),
num((if(Units='%',Num(Sum([Jun-2023]/100),'#,##0.0%;(#,##0.0)%;-') ,Num(Sum([Jun-2023]),'##.00'))), '#.##0,##', ',', '.')))

Also changed to Measure expression.