Average calculated in Crosstab

[sjoerd.jump]

Hi Guys (and girls) 

 

Im struggling with the following problem in iReport:

 

I have a crosstab with uptimes for  2 systems. (the top 2 rows) over the past month.

Now 1 system went down somewhere during the month (decreasing uptime percentage) and our supplier made arrangements to have the problem fixed. This would take some days to fix so we agree to _not count_ the system availability (does this make sense?)

 

Anyway.

 

After evaluating the availability KPI I run into a disagreement with my supplier. Jasperreport says the Availability is 98.61% but Excel thinks it's 98.72%

This is caused by Jaspersoft calculating the Average based on ALL the cells in the first 2 rows where Excel calculates it based on the AVERAGES per day.

Is there any way to change the calculation inside Jasperreport from cell to average per day?

 

Cheers,

Sjoerd

 

100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100
100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	95.8	75	75	75						96,95
100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	97.9	87.5	87.5	87.5	100	100	100	100	100	98,61

 

[sjoerd.jump]

Right now I use a workaround

have added a variable to my report that calculates an average availablity over the 2 systems.
In the crosstab i have added a new measure with my new variable as expression, set to average again.

This is now an "average average" just what i was looking for.