I have Number DataCardValue that name Total Amount and 12 DataCardValue refer to months,
I implement formula that divide Total Amount/12 to each DataCardValue
RoundDown(DataCardValue5.Text/12, 0.00)
but it not getting whole number for example 50/12 must be 4.16 but calculate 4.00
Hi @Anonymous221221 ,
Floating-point arithmetic is approximate, so it can sometimes give unexpected results with many documented examples. You might expect the formula 55 / 100 * 100 to return exactly 55 and (55 / 100 * 100) - 55 to return exactly zero. However, the latter formula returns 7.1054 x 10–15, which is very small but not zero. That tiny difference doesn't normally cause a problem, and the app rounds it away when showing the result. However, small differences can compound in subsequent calculations and appear to give the wrong answer.
I think this link will help you a lot:
https://learn.microsoft.com/en-us/power-platform/power-fx/data-types#number-and-currency
Best Regards,
Bof
Thanks It's working but when i sum all values it's not accurate
For example 50/12 = 4.1666 Now It's working fine but when I sum 4.166 twelve time it give 49.9999 instead of 50. Can you have solution of it