Custom Aggregation-functions

mgrohmann

Hey,<br />
<br />
after finding a solution for calculating values from other columns (<a class='bbc_url' href='http://www.birt-exchange.org/forum/designing-birt-reports/16884-math-functions-crosstabs.html)'>http://www.birt-exchange.org/forum/designing-birt-reports/16884-math-functions-crosstabs.html)</a>, I want to aggregate these calculated values in the aggregation functions.<br />
<br />
The problem is, that I'm only able to use "measure["value"]" as data field. I need to address other column values like<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>parseFloat(reportContext.getPersistentGlobalVariable(1))+ parseFloat(reportContext.getPersistentGlobalVariable(2));</pre> and SUM oder AVG them.<br />
<br />
How can I address them in my aggregation as Data Field?

mwilliams

Hi mgrohmann,

If I'm understanding correctly, you should be able to sum these values in script on your own and show the total where you want using another variable. You should also be able to count the number of rows with a variable to be able to compute the average on your own. If I'm misunderstanding, maybe setting up a simple report using the sample database with this idea set up in it would help.