<p>Hi,</p>
<p> </p>
<p>I have a report where in certain situations the aggregation function is returning the wrong value from a column_binding field. A simplified version of my issues is that I have a column_binding field that totals (paymentType1 + paymentType2Agg) - (expenses) = staff compensation. Simple enough and works in 99% of cases.</p>
<p> </p>
<p>In this case the staff member put in for 800$ of compensation and there are 200$ in expenses. The customer only paid 800$. So 800$ - 200$ = 600$ in my column_binding field(actual compensation) and I see that on the screen when the report runs. Now, when I then create an aggregate on that field so I can total up all compensations across multiple invoices I get 800$ (in this case I only have one Invoice so it made it simple to spot). It's like it is ignoring the math and just putting in the requested staff compensation. Has anyone seen anything like this before? Is there a limitation to how man aggregations or column_bindings you can have on a report? </p>
<p> </p>
<p>I have tried taking the entire compensation calculation and placing it into the aggregation. I have tried setting a global variable on the column_binding field and then pass the variable into the aggregation. Nothing seems to work in this case. Is there a way I can manually do aggregation in the onCreate or onRender for a given grouping?</p>
<p> </p>
<p>I am on Birt 4.5.0. Some background: this is a fairly complex report with over 30 computed fields, 23 column_binding data fields, over a hundred aggregation fields, and a subtable added in for good measure. FYI I inherited this report about a year ago and had to keep adding to it and fixing business/calculation errors over that time period. So I probably wouldn't have designed the report this way if I was the one that originally created it.</p>
<p> </p>
<p>Thanks in advance,</p>
<p>Mark</p>
