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; } } }

AVE on crosstab

oraBirt

HI,
Thanks for your help in advance!
Birt designer version is 3.7, a Summary field is set as sum( no ave in data cube), after this field is placed in crosstab, right click it and change its function as AVE. The problem is some of the calculation are right, and some are not.
Not sure what I did wrong, any help is appreciated!

Find more posts tagged with

Comments

kclark

Can you recreate this and post the rptdesign for me to look at?

oraBirt

Thanks very much!Please see the attached files.

kclark

Not sure how your table is setup, but, if your using avg() in your query like it looks like you are in the dataset. Then try selecting last as the aggregation.

oraBirt

Thanks, do you mean to do the avg() in birt query?
the problem is there is no avg() in birt function or native javascript functions.
Any ideas? Thanks very much!

wwilliams

The Sql you attached with the excel sheet has the average, is that working for you?
If so as Kristopher suggested use LAST as the aggregation choice, so Function would be LAST.

oraBirt

Getting sum, count, then "add Derived Measure" solved the problem.
Thanks very much!