Percentage change between to expressions

[peter789]

Hi,

i am  trying to find a formula for a KPI where two expressions get compared and  the output should be in percentage.

I used to do this with: 

=((Sum({$<Arbeitspl.={0101}>}[Menge (ER)]))

/

(Sum({$<Platz={'S1'}>}[WIP T1])))-1

This works fine for me, but if one of the numbers is Null ("0") it obviously doesn't.

Any ideas? 

[jyothish8807 · Accepted solution]

Hi Peter,

May be try Alt function, as if your denominator become then you are expected to get null value. So you can use alt in such cases.

Alt(

((Sum({$<Arbeitspl.={0101}>}[Menge (ER)]))

/

(Sum({$<Platz={'S1'}>}[WIP T1])))-1

,'NA')

[PriyankaShivhare]

if i understood it right...

if(Sum({$<Platz={'S1'}>}[WIP T1])=0,Sum({$<Arbeitspl.={0101}>}[Menge (ER)]),((Sum({$<Arbeitspl.={0101}>}[Menge (ER)]))

/

(Sum({$<Platz={'S1'}>}[WIP T1])))-1)

Thanks,

Priyanka

[peter789]

Thank you, 

it was a little different but i found a solution with your help!