Jump to content
Changes to the Jaspersoft community edition download ×

Average of a Group

2005 IR Help

Recommended Posts

By: Brett - bsutton

Average of a Group

2004-11-24 17:25

I'm trying to calculate the average of a group.

I have create a variable for the group which correctly sums the details of the group.

<variable name="SUM_FOR_DAY" class="java.lang.Integer" resetType="Group" resetGroup="Date" calculation="Sum">




I then created a variable which is intended to print an average of the group at the end of the report.


<variable name="AVERAGE_FOR_PERIOD" class="java.lang.Integer" resetType="Report" calculation="Average">




However the value printed is clearly not the average.


Can any one suggest where I'm going wrong?






By: Teodor Danciu - teodord

RE: Average of a Group

2004-11-25 00:44




You average variable should look like this:


<variable name="AVERAGE_FOR_PERIOD" class="java.lang.Integer" resetType="Report"

calculation="Average"> <variableExpression><![CDATA[$F{Count}]]></variableExpression>



I hope this helps.







By: Brett - bsutton

RE: Average of a Group

2004-11-29 19:41

Thanks for the reply but thats not quite what I'm looking for and I probably didn't explain it very well.


What I'm trying to do is determine the average of the groups not the individual line items.


As an example

if D: represents a detail line with a value

and G: represents a group line with a value which is the sum of the associated detail lines.


D: 4

D: 1

G: 5


D: 1

D: 3

D: 1

G: 4


The the average should be 4.5 as calculated by:

4.5 = (5 + 4) / 2 where 5 and 4 are the group totals.


Your proposed solutions yields:

Average = 1.8 which is 9 / 5

i.e 9 is the total of all detail lines and 5 is the no. of detail lines.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...