Subtracting two fields

[robertdseals]

 Hello,

I am VERY new to this.  I'm trying to subtract two fields in ireport 4.1.1

$F{CAD}

$F{CMD}

I tried putting $F{CAD} - $F{CMD} into a text box but that didn't work.

I would like to use Designer view, but can use the XML view if you give me enough code.

thanks,

[despec]

Like so:

 

new java.Math.BigDecimal

(

$F{CAD}.doubleValue() - $F{CMD}.doubleValue()

)

 

 

David

[robertdseals]

In the text box?

[despec]

You would create a new Variable and put this within the expression field.

 

David

[robertdseals]

  startup failed:
calculator_report3_1314911259878_197438: 201: unable to resolve class java.Math.BigDecimal 
 @ line 201, column 21.

[robertdseals]

Changed to:

$V{new java.Math.BigDecimal($F{CAD}.doubleValue() - $F{CMD}.doubleValue())}

and still not working.

[robertdseals]

If it helps any, here's some of the XML

<reportElement x="100" y="0" width="100" height="20"/>

<textElement/>

<textFieldExpression><![CDATA[$F{CAD}]]></textFieldExpression>

</textField>

<textField>

<reportElement x="200" y="0" width="100" height="20"/>

<textElement/>

<textFieldExpression><![CDATA[$V{new java.Math.BigDecimal($F{CAD}.doubleValue() - $F{CMD}.doubleValue())}]]></textFieldExpression>

</textField>

[robertdseals]

 I had the fields and the variable set to "sting".  I'm assuming I need to set it to "double" or something else?

[despec]

Yep...The resulting variable should be set to bigDecimal....

 

David