Aggregator Stage error

kravids · Post by **kravids** » Fri Jul 23, 2010 2:17 pm

Hi,
Iam using aggregator stage for calculating amounts. In the output iam getting small difference. Below is the example

Input Output
12.34 12.32
99.99 99.97
78.23 78.21
Should i need to change any options so that i can get acurate result...

anbu · Post by **anbu** » Fri Jul 23, 2010 2:30 pm

What is your input and output field type and length?

kris007 · Post by **kris007** » Fri Jul 23, 2010 2:53 pm

Usually, Aggregator Sum/Difference output is defaulted to Double ( datatype). Try changing it to Decimal and you should be good.