>>>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.
Actually, it's not affected by SET DECIMALS if you specify the TRANSFORM() format.
If you don't specify it - TRANSFORM(CurrencyField)
, then it is affected by SET DECIMALS
Insanity: Doing the same thing over and over and expecting different results.