Page 1 of 1
Calculated Field Gone Crazy
Posted: Thu Mar 17, 2005 4:19 pm
by 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
=> RE: Calculated Field Gone Crazy
Posted: Thu Mar 17, 2005 9:40 pm
by 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
==> RE: Calculated Field Gone Crazy
Posted: Mon Mar 21, 2005 9:35 am
by Alan_Klein
I think Kathleen inadvertently added an extra parenthesis in one line above. It should read: TPJAN=ROUND(TJAN/INCDEC,4)
===> RE: Calculated Field Gone Crazy
Posted: Mon Mar 21, 2005 9:36 am
by Alan_Klein
Also in the line above, which should read: TJAN=ROUND(CJAN+PJAN,0)__