Calculated Field Gone Crazy

[Miguel_(Guest)]

Can someone see if they can reproduce this calculation error. I want to make sure it^s not just me.____CJAN=19386__PJAN=171__TJAN=(CJAN+PJAN) =19557____INCDEC=160000____TPJAN=TJAN/INCDEC =.1222__ __QJAN=INCDEC3*TPJAN =19552 <----when i run this i get 19557____If I make a another calculated field like this TEST=160000*.1222 it returns 19952. I am doing something wrong? I hope so.____Someone please tell me I^m not crazy. It^s been a long day!____Thanks,__Miguel

[kfleming]

You need to add the round() function to your expression.__Try:__TJAN=ROUND(CJAN+PJAN),0)__TPJAN=ROUND(TJAN/INCDEC),4)____Kathleen__R&R Support

[Alan_Klein]

I think Kathleen inadvertently added an extra parenthesis in one line above. It should read: TPJAN=ROUND(TJAN/INCDEC,4)

[Alan_Klein]

Also in the line above, which should read: TJAN=ROUND(CJAN+PJAN,0)__