$V calculation type=sum, result not right

[kz]

I define a field "totAmt" to sum all the "yitemval" in table

<field name="totAmt" class="java.lang.Float"/>

<field name="yitemval" class="java.lang.Float"/>

 

<variable name="totAmt" class="java.lang.Float" resetType="Report" calculation="Sum">

<variableExpression><![CDATA[$F{yitemval}]]></variableExpression>

</variable>

 

and output the totAmt at the end of the report:

<textFieldExpression   class="java.lang.Float"><![CDATA[$V{totAmt}]]></textFieldExpression>

</textField>

and it gets incorrect result.

I have an example here

total amount should be 149968.45, but V{totAmt} shows 149968.44

what's the problem??

 

[idstewart]

Try BigDecimal instead of Float