>>>>Hello all,
>>>>
>>>>In my report I have currency fields. There are 4 decimals for those fields. How can I have only two decimals?
>>>>
>>>>Thanks in advance.
>>>
>>>#1 is this CURRENCY as field type or just a number with four decimals?
>>>#2 Try to format it. The report field edit form offer fields for this. Format expression like 999999.99. See
Format Expressions for Field Controls in vfp help. Check if the result is as expected (problems with rounding?)
>>
>>Use round(myCurrencyField,2) as the expression, in that case.
>
>As for currency, ROUND() might be wrong. Book-keeping is not engineers maths. This is more CEILING. Why I wrote
check>
>Update:
>Aside where to round and sum.
I did hit that wall back in 1990. Morale of the story: keep the numbers in the format that accountants keep them. Never calculate anything twice. Store rounded. For percentage of the total, don't calculate it, sum the individual values of the percentage applied to each line item. It's less correct, but it adds up.
The reason that currency fields have four decimals is not the currency values themselves, it's for exchange rates.