nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem with Aggregation (Average)

h3llraid3r

Hi, 
I'm stuck at another problem: 
 
I made one Report with Average as Aggregation, the values in the output are right. 
 
Making another Report with the same properties runs into wrong output values, although the properties are the same. The first report returns the average, the second returns the max value. 
 
To show what I mean: 
 
1) CSV data source (from the right one): 
<img src='http://www.pictureupload.de/originals/pictures/011210135108_csv_ok.JPG' alt='Posted Image' class='bbc_img' /> 
 
Output (Average is shown): 
<img src='http://www.pictureupload.de/originals/pictures/011210135238_avg_ok.JPG' alt='Posted Image' class='bbc_img' /> 
 
2) CSV data source (from the wrong one) 
<img src='http://www.pictureupload.de/originals/pictures/011210135357_csv_false.JPG' alt='Posted Image' class='bbc_img' /> 
 
Output (Max Value is shown): 
<img src='http://www.pictureupload.de/originals/pictures/011210135456_avg_false.JPG' alt='Posted Image' class='bbc_img' /> 
 
I'm really confused, because in my opinion, the properties are all the same. (Type, Aggregate on, etc). 
First, I thought that the joined dataset is my problem, but when I create a crosstab with an "normal" dataset, the problem occurs, too. 
 
Is there a property that I have to mention?

Find more posts tagged with

Comments

mwilliams

Hi h3llraid3r,

Can you attach your report design?

delonge182

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71130" data-time="1291754560" data-date="07 December 2010 - 01:42 PM">
Hi h3llraid3r, 
 
Can you attach your report design? </blockquote>
 
Hi mwilliams, 
 
I have a problem with BIRT : 
 
-i have 2 columns (integer), then i want to get average value of it and place it to one control. 
 
for example : 
 
i have columnA and columnB 
value of columnA = 10 and columnB = 6 
and i want to make another column which it value is 8 (average of columnA and columnB) 
 
and i don't want to use manual way ((columnA + columnB) /2). 
 
is that possible? 
 
thanks

mwilliams

What is wrong with doing it the manual way in a computed column? Is this in a crosstab or a standard table?

delonge182

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73968" data-time="1298653845" data-date="25 February 2011 - 10:10 AM">
What is wrong with doing it the manual way in a computed column? Is this in a crosstab or a standard table? </blockquote>
 
hi mwilliams, 
 
this is a standard table 
 
I've tried the computed column 
 
Column Name : averageColumn 
Data Type : float 
Aggregation : AVE 
 
but i don't know what to put in Expression. 
could you tell me what to put in the expression, so the value of the computed 
column will always the average of 2 columns(columnA and columnB). 
 
thanks.

mwilliams

You would simply do a computed column with the expression A + B / 2 if it's simply going to be the average of these two columns all the time. You'd just do this in your dataSet through the dataSet editor.

delonge182

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="74045" data-time="1298908410" data-date="28 February 2011 - 08:53 AM">
You would simply do a computed column with the expression A + B / 2 if it's simply going to be the average of these two columns all the time. You'd just do this in your dataSet through the dataSet editor. </blockquote>
 
I got it. 
 
Thanks a lot.

mwilliams

Not a problem. Let us know whenever you have questions.