how do do conditional variables

[tonyg]

Hi, I am calculating margin to a variable.(below) this works most times, but every so often, i get a divide by zero error. Is there a way to put an if-then in to check for 0 ?? how?

 

thanks

 

 

<variable name="Cat_Margin" class="java.math.BigDecimal" resetType="Group" resetGroup="SHORT_NAME" calculation="Nothing">

<variableExpression><![CDATA[($V{Cat_Price_Total}.subtract($V{Cat_UPC_Total})).divide($V{Cat_Price_Total},new MathContext(100))]]></variableExpression>

</variable>

[raulinon]

Hi Tonyg,

What language are u using to generate the jasper report? (php asp delphi ???)

[tonyg]

Hi,

Thanks for the reply. i am not sure how to answer your question, I use IReports to create the report, is that what you were asking?