Aggregator Stage

[dsconultant]

Hi,
Is it possible to sum negative values in aggregator stage?

I have a job in which I use an aggregator stage to calculate the sum. If the column has positive values the sum amount is correct, but if there is a negative value then the amount defaults to 0.

e.g
Key_Col Value_Col
1 1
1 1
2 -1
2 -2

For my result I should have

Key_Col Sum_col
1 2
2 -3 but instead it is 2 0.

My group_by column =Key_Col
Aggregation_type=Calculation
I use the Sum option and define my output column. I checked to see if there were any option for negative values but did not see any.
How can this scenario be handled?

Thanks.

[ray.wurlod]

What is the data type of Value_Col? In particular check the extended properties and inform us whether it is of type uint (unsigned integer).

[dsconultant]

It is not UINT. I am not 100% sure but it is either a numeric or decimal field and has no extended properties set.

[ray.wurlod]

Be sure. Check.