Issue with num function in if conditional

[RutiTaumanRubin]

Hi,

I have the following measure in extension Simple KPI:

if(GetFieldSelections([Type])='Percent',

num(count(distinct APP_ID)/100,'#,##0%')

,num(count(distinct APP_ID),'#,##0')

)

I defined the number formatting as measure expression , but the percent doesn't work

If i just write num(count(distinct APP_ID)/100,'#,##0%') - not in if conditional -  it works..

Could you please advise?

Thank you!

Ruti

[Anil_Babu_Samineni]

Why can't you simply use this?

if(Type='Percent', num(count(distinct APP_ID)/100,'#,##0%'),num(count(distinct APP_ID),'#,##0'))

[RutiTaumanRubin]

Thank you for your response.

It doesn't work in if condition even when I try to write:

if(1=1, num(count( APP_ID),'#,##0%'))

without if condition it works...

I see that the problem exists in the extension Simple KPI ...

[RutiTaumanRubin]

Thank you for your response..

I dont really understand how to use it ..

[Anil_Babu_Samineni]

If(1=1, ...) What this condition do? Just to know? Do you try mine?

[RutiTaumanRubin]

It doesn't do anything.. just to prove that the problem happend in if condition...