<p>Hello.</p>
<p>I'm trying to count a basic "Excel"-like sum in a BIRT report (output in excel).</p>
<p> </p>
<p>The field I'm using is dynamic aggregate SUM and vary on a given condition, meaning that a value in the field can be retrieved from 2 different fields. The "aggregate" field I'm trying to create AND the field it get's its values from are both presented in two different report group footer rows.</p>
<p> </p>
<p>The formula I'v used is:</p>
<p>if(row["palvelutuottajaosaid"] != null && row["palvelutuottajaosaid"] != ""){<br>
row["palautteet_osa"]}<br>
else row["palautteet"]</p>
<p> </p>
<p>Now, normally aggregate is attached to a certain field/column. If I use this field in aggreagate, the sum is something like 402 instead of 25.</p>
<p> </p>
<p>Is there some easy way of counting just the values in a certain column that can already be seen there?</p>
<p> </p>
<p>I'll attach a screen shot where I've marked the values I'm trying to achieve in red color.</p>
<p> </p>
<p>I've searched the forum for an answer, but didn't manage to find a solution I could use. The simplest one I found is shown below, but the binding just broke the report and I ended up having an excel with no data in the main table.</p>
<p> </p>
<p>:Total.sum(dataSetRow["yourRow"])</p>
<p> </p>
<p>Thanks in advance, Elja</p>
