Sum of Nulls- Aggregator
Posted: Fri Sep 19, 2008 12:58 pm
Hi,
I have a job as follows
InDataset-->Aggregator---> OutDataset
The InDataset has three fields a,b,c. In the aggregator the group by is on a,b and summation of c. C can have values, Null,0,+ve or -ve numbers.
The problems is that all sum of nulls is converted to 0 in OutDataset. Hence I cannot figure out if the 0 is due to nulls or due to summation.
In Oracle a sum of nulls returns null, but not in DS.
Any way how to figure this out?
Regards
Ankur
I have a job as follows
InDataset-->Aggregator---> OutDataset
The InDataset has three fields a,b,c. In the aggregator the group by is on a,b and summation of c. C can have values, Null,0,+ve or -ve numbers.
The problems is that all sum of nulls is converted to 0 in OutDataset. Hence I cannot figure out if the 0 is due to nulls or due to summation.
In Oracle a sum of nulls returns null, but not in DS.
Any way how to figure this out?
Regards
Ankur