>>Make a table with two fields one currency and the other numeric with three decimals
>>Put this value in the fields 27.0760 in currency and 27.076 in numeric
>>Do a transform(CurrencyField,'$,$$9.99') value = 27.07
>>Do a transform(NumericField,'$,$$9.99') value = 27.08
>>
>>Does any body have a work around for this or know why?
>>
>>
>>Shawn Dorion
>>E :
Shawn@OurSoftware.com
>>
>>Web: www.oursoftware.com
>
>The fact that you are transforming a number field from three decimals to two forces a round function on the transformation. With currency fields, the accuracy is preserved, but the value is truncated.
>>?transform(round(numbs,3),'$,$$9.99')
This behavior is related to SET DECIMALS
Try: SET DECIMALS TO 5 and see what kind of results you get.