Need help with EXPRESSION for divide by zero or NaN

[jkeri]

I need to create a java  expression as follows.

all my $V variables are java.math.BigDecimal:   BASE, AVG, VAR

 

If BASE / 0 gives a DIVIDE BY ZERO or NAN error then RESULT = 0       ELSE    RESULT = (AVG - VAR)/VAR

 

 

 

 

[dszeto]

How about in your dividend check whether that subtraction is > 0 and if not, set the dividend to 0. 

Once that is done then you can do an <expression> ? 0 : <result>. I am not sure how you would check if the result of the division is NULL unless you are checking whether the variables themselves are NULL.