Aggregation Builder returns no value

GoranG

Hi all.

upon adding an aggregation builder with filter condition to my BIRT report, it happens that there is absolutely no value present. I'd like to have a 0.0 in such case. How to achieve this?

More info: I have three aggregation builders.
AB 1: Name = Difference, Data Type = Float, Function = SUM, Expression = dataSetRow["overallDifference"], no filter expression.
AB 2: Name = Negative Difference, Data Type = Float, Function = SUM, Expression = dataSetRow["overallDifference"], filter expression = dataSetRow["overallDifference"] < 0.0
AB 2: Name = Positive Difference, Data Type = Float, Function = SUM, Expression = dataSetRow["overallDifference"], filter expression = dataSetRow["overallDifference"] > 0.0

Experimenting (testing) this result with only row in "overallDifference" I get either positive difference printed out (some actual value), and no result in the negative difference field. Or vice versa. How can I "convince" the aggregation to return 0.0 even if everythign is filtered out?

Oh, maybe important: Format Number is set to ###,##0.00, and locale is set (to Swiss).

If this topic was already answered, please guide me to the correct topic. I tried searching but didn't find it.

Thanks,
G

mwilliams

Hi G,

If I'm understanding correctly, you could just put this in your onCreate script of your aggregation element:

if (this.getValue() == null){
this.setDisplayValue(0);
}

Hope this helps.