Expression

[#1]

Hi all,

I got this expression:

If(isnull((SUM({$< Year = {$(=(max(Year)))} >} RevenueAmount))/(SUM({$< Year = {$(=(max(Year)-1))} >} RevenueAmount))-1), 0, (SUM({$< Year = {$(=(max(Year)))} >} RevenueAmount))/(SUM({$< Year = {$(=(max(Year)-1))} >} RevenueAmount))-1)

However now I got my formula twice. Because the first part says if it's null you have to value it with 0. Then if it's not null it has to calculate the formula again.  This will probably effect my system capacity so I thinking is there an other way to solve this?

kind regards

[jonathandienst · Accepted solution]

Hi

Use Alt():

=Alt(((SUM({$< Year = {$(=(max(Year)))} >} RevenueAmount)) / (SUM({$< Year = {$(=(max(Year)-1))} >} RevenueAmount))) - 1, 0)

Alt() will return the first parameter (your expression) if it is not null*, otherwise returns the second.

HTH

Jonathan

*actually if it is not numeric, but a null is non-numeric so it works in this case

[its_anandrjs]

Another way you can use variables for this like

if(Isnull($(YourExpression),0 ,$(YourExpression))

Hope this helps

Thanks & Regards

[tresesco]

Try with alt(), like:

=Alt(yourExpression_once, 0)

Note: The alt function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. Any number of parameters can be used.

Or, use you can use variable instead of direct expression. Using variable twice would not recalculate unlike you are afraid of performance.