To make the Aggregator return zero ("0") when all values of grouped by columns are Null do the following:
Log in to the PowerCenter Administration Console.
Select the Integration Service.
Under Compatibility and Database Properties select "Yes" for AggregateTreatNullAsZero.
Restart the Integration Service for the change to take effect.
PowerCenter Administrator Guide > "Creating and Configuring the Integration Service" > "Configuring the Integration Service Properties"
What can we do to improve this information (2000 or fewer characters)