Maybe I’m doing something wrong, but it’s driving me crazy! Somehow this sum is summ 2 cents less…I have everything set to 2 decimals, but even when I set it to 8 digits, it sums 88,41…and it should be 88,44. This happens to me too often, not sure if I have some setting wrong…
Please help me, this is making me lose too much time double-checking amounts!
Found the solution! ChatGPT helped me!
Maybe this helps others: the formulas I had before getting to this number were a number, not a currency. When I forced the formulas to round to 2 decimals, it worked! I guess I will have to check all the formulas and round them all!
A number (money or otherwise) will be stored with as many decimal places as are provided by the user. The decimal place setting only serves to limit what is shown on the UI.
In other words, if you have the UI set to show 6 d.p.s and you enter 3.456789, even if you change the display to 2 d.p, the number stored will remain the same. And if you use that number in a formula, all digits will be used (unless you deliberately use a rounding function).
I always entree the number with 2 decimals , the problem is on the formulas in between. let say I enter the Net price then I have a formula the should the VAT and another formula that calculate the Gross, then another formula multiplies the Exchange rate currency the price in €. The entry number is not currency because that varies all the time. But the last formula is currency. This formulas in between are probably resulting many digits, right? That’s why I need to round all formulas to 2 digits?
Yes, I imagine the issue is that your maths functions can result in a number which has more than 2 d.p.s
e.g.
1.23 x 4.56 = 5.6088
Also, perhaps your exchange rate has more than 2 d.p.s ?
The choice between decimal number and currency is UI only - it doesn’t affect calculations.
The correct solution probably depends what the accounting procedures are in your country(!)