Variable with calculation as highest and lowest

[davidbhybrid]

I cannot seem to get this to work. I have tried several variations of the Variable. Here is what I am trying to do:

I have a variable named mth_job_gross this variable is set the following:

Class: java.math.bigdecimal

Calculation: Sum

Reset Type: Group

Reset group: month_recd

Variable Expression: $F{job_gross}-($F{cash_discount}+$F{other_discount})

I would like to get the HIGHEST and LOWEST valuses returned in a varaible for the SUmmary of the report, but the lowest variable grabs ONLY the lowest record NOT the lowest of the sum (variable above).

Any ideas how to solve this? Am I doing something incorrectly? Thanks in advance!

I have also attaced my JRXML file.

Post Edited by djbolduc at 09/07/2012 01:24