Hello,
does anyone have same issues with calculations? Please see screenshots…
Opening entry, the calculation field shows:
-> 0810
The calculation is correct after pressing CMD-R 2-3 times:
-> 810,26 €
But the problem keeps coming back.
Thanks in advance
Chris
Attachments:
You must be
logged in to view attached files.
Have you tried just doing the subtraction operation without the formatting to see if the output is stable there?
One other thought is after doing the above, also set it to number as a return value and use the “Number Format” as “Currency Style”, select “Euro” for the currency and set the decimal places to two.
The FORMAT() function should work as you have it there. I’m not sure why you’re seeing this behaviour. I was testing it and it seemed to be working correctly.
Attachments:
You must be
logged in to view attached files.
Thanks for your time. I changed the formula as Sam suggested and back again to my previous formula. Now it works correctly, but i don’t know why… I hope the problem won’t recur …