>>>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?
>>
>>As mentioned by several others, the answer here is yes. As suggested in Q258998, you might be able to use ROUND(nAmount, 0) instead of INT(nAmount) to get the value you expect.
>
>Garrett,
>
>In this case yes:
>Round(16.0000,2) gives 16
>Int(16.0000) should be 16 right? but it gives 15 which is attributed to what others are saying.
>
>What if?
>Round(16.5555,0) gives 17
>Int(16.5555) gives 16
>
>We just want to get the Integer value.
>
>What is the best alternative data type over numeric type?


Wait a minute, you put in INT(16.0000) and it gives you 15? Even when you use the constant 16.0000? Or am I mis understanding you. I get 16 on my machine...