>Hi Terry
>
>>But that's goverend by SET DECI anyway, isn't it? So a numeric field can also have 4 decimals.
>
>Probably yes, but the field in the table will always have 4 decimals. I have never tried it this route but my fear is as follows:
>
>For eg. the calculated currency values generated and stored without rounding.
>
>123.4321
>234.5432
>--------
>357.9753 rounded 357.98
>
>123.43
>234.54
>------
>357.97

Indeed, you get different answers if you round each intermediate result, compared to rounding the final result.

Something similar happens without explicitly rounding, just by using currency values. Usually, if a calculation involves currency values, all intermediate results are converted to currency. That means, they are rounded to 4 decimals.

For example:

? a / (b * c)

where "c" happens to be of type currency, my understanding of the calculations are as follows:

For the multiplication, b must first be converted to currency. Here you may already get unexpected results, due to the rounding.

Next, the multiplication is done, rounded to 4 decimals. Finally, I suppose "a" will also be converted to currency, before doing the division.