Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Average by rows aggregation different from average by total aggregation
Migrateduser
Hello. I'm new to BIRT. I have the following problem:
2 columns with 5 row values.
col1----col2
0.03----0
0.75----7.27
27.4----348.05
31.04---332.64
19.43---237.58
1.81----16.7
Total 80.46----942.24
If I divide total col1 by total col2 the result is 0.0853 - the correct result. I don't want to use aggregation of aggregations since data is dynamicaly filled.
The expression I used for AVG is:
dataSetRow["col1"]/dataSetRow["col2"] with filter dataSetRow["col2"] > 0
The result is different from the total average: 0.093 , as it's calculated only for 5 row of 6 ....
Can you please help me with the expression?
Find more posts tagged with
Comments
There are no comments yet