How to sum an Field

[nitin403]

Hi! to All.

I need to get total of an Field.

So How to add or sum an single field.

Examples will also be very helpful.

Thank you in advance.

[fabismt]

You can add a variable using a field as expression and setting the calculation type as SUM.

 

Sample:

 

<variable name="VARIABLE_SAMPLE" class="java.lang.String" resetType="Report" calculation="Sum">

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

</variable>

 

Try iReport if you are not using it yet.

 

HTH

[nitin403]

Hi fabismt!

Thanks a lot

I am using iReport.

But I don't know how to create variables and how to use them.

I am a bit confused:blink: about using variables.

What I want to do is get the summation of a field.

The field has a Double value.

And in the columnFooter I want to show the sum of that Field.

Thanks a lot once again.