Doing calculations in a report IF statement.

[gregory.west]

Is this allowable in Jasper Studio:

IF(($V{DID_BW}==0 && $V{DID_Colour}==0),0,($V{DID_Copy}/($V{DID_BW}+$V{DID_Colour})))

This is the assignment for a variable that is being printer on a report.  What I am trying to do is print 0.00 is DID_Colour and DID_BW are both zero, otherwise do the calculations.  This is being done to prevent the divide by zero error from happening.

[javier.ggi90]

Try something like this instead:

$V{DID_BW}==0 && $V{DID_Colour}==0 ? 0 : $V{DID_Copy}/($V{DID_BW}+$V{DID_Colour})

 

? = THEN
: = ELSE

For future references, you can also nest them.

[gregory.west]

WOW the syntax of Jasper takes a little getting used to, but my oh my Jasper is 1,000 times more powerful than programs I have have to pay thousands of dollars for.