Thanks a lot Larry
It did the job. Still I'm uncomfortable by knowing that VFP operations does not make the necessary adjustements for the result in order to obtain better precision, it could be a particular issue with currency variables.
Regards
Oscar
>>I'm making a divide operation between two currency variables and an integer:
>>
>>lnResult = lnCurrency1 / lnInteger / lnCurrency2
>>
>>No matter how I group this operation, the result gives me acurrency result with a precision of 4 decimals.
>>
>>Due to the nature of the numbers I'm handling, and the volume of the data being handled, I´m loosing some significant amounts.
>>
>>How can I get a higer precision number with at least 6 decimal places?
>>
>>Thanks in advance for any hints.
>>
>
>Oscar,
>The currency data type is limited to 4 decimal places. If you want larger precision, convert it before you perform the operation using the MTON (money to number) function.
>
>Ex.
>lnResult = mton(lnCurrency1) / lnInteger / mton(lnCurrency2)
>
>HTH.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only