web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Division function not ...

Power Apps

Answered

Division function not getting decimal numbers

(0) Share

Report

Report

Posted on by Anonymous221221

36

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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous221221 ,

Please try:

RoundDown(DataCardValue5.Text/12,2)

Best Regards,
Bof

Was this reply helpful? Yes No
Anonymous221221 36 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

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

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation