>We have a field which is set as Numeric type say Amount N(10,4). Value of which was derived from different variables and fields (n1+n2+n3, etc.). Somewhere in the module, it is clear that Amount has a value of 16.0000 being shown in the debugger, but if we try to make use of INT(Amount), it gives us 15. Trying to do the same procedure in the command window but this time using variables, it produces the correct result. Is there a hidden anomaly of using a Numeric type?

Jess,

If n1 + n2 + n3 > 15.9994 then the value stored in the field will be 16.0000. INT(n1 + n2 + n3) = 15, but INT(amount) will be 16.