Set Aggregation value if null due to Filter Condition?

I've got an aggregation (SUM) on a field that is set to aggregate on a group in BIRT 2.6.2. The problem is there are times when the aggregation may not find any fields to sum up, based on the Filter Condition.
<pre class="_prettyXprint">
Column Binding: total_hours
Diplay Name: Total Hours
Data Type: Float
Function: SUM
Expression: dataSetRow["regularhrs"]
Filter Condition: dataSetRow["schedstart"] > row["date1"] && dataSetRow["schedstart"] < row["date2"]
Aggregate On: crewIDGrp (Group)</pre>
I know the aggregation works because the summary will return values when there is data between the two date ranges. But when no records exist in the date range, the summary returns NULL instead of 0.00.
 
Any suggestions on how to get the aggregate to return 0.00 in the event no data meets the Filter Condition?

Find more posts tagged with

Comments

micajblock

Do you want to just display 0.00? If yes use mapping. Another option is to create another column binding and have the expression:
<pre class="_prettyXprint">
if (row["total_hours"] == null) {
0;
}
else {
row["total_hours"];
}</pre>

jverly01

That's exactly what I ended up doing. The 2nd element will do a check on the actual aggregation and if the aggregation is null, set its value to zero.