Unanswered

Error using the Sum function

(0) Share

Report

Posted on by joaocsantos

Collect(colValores,{val: 84.7});
Collect(colValores,{val: 7.65});
Collect(colValores,{val: 7.65});
UpdateContext({locSum: Sum(colValores,val)})
//locsum = 100
//locsum > 100 returns true
//because locsum is in fact 100.0000000001
 
if i reverse the order of the collect to
 
Collect(colValores,{val: 7.65});
Collect(colValores,{val: 7.65});
Collect(colValores,{val: 84.7});
 
//locsum = 100
//locsum > 100 returns false
 
 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

RobHardy 154 on at

Like (2)

Report
Copy link

Link copied!

Unfortunately, floating point errors are quite common across many programming languages / platforms.

Since your values are all 2 decimal places or less, you could round the result to 2 places, which should fix the issue:

UpdateContext({locSum: Round(Sum(colValores,val),2)})

Was this reply helpful? Yes No
ronaldwalcott 3,847 Moderator on at

Like (0)

Report
Copy link

Link copied!

In some of these situations such as currency it may be better to work with integer values then convert them back.

Was this reply helpful? Yes No