Answered

"Invalid operation: division by zero"

(0) Share

Report

Posted on by nick9one1

353

I'm getting the above error in my app, despite the division not being by zero. The calcualtion works, giving a total performance score.

Round(Sum(Gallery5.AllItems,performanceScoreValue)/CountRows(Filter(Gallery5.AllItems,!IsBlank(performanceScoreValue)&&performanceScoreValue.Text<>"0")),2)

Screenshot 2023-07-31 121059.jpg

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Shaheer Ahmad 2,194 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try:
If( CountRows(Filter(Gallery5.AllItems, !IsBlank(performanceScoreValue) && performanceScoreValue.Text <> "0")) > 0, Round( Sum(Gallery5.AllItems, performanceScoreValue) / CountRows(Filter(Gallery5.AllItems, !IsBlank(performanceScoreValue) && performanceScoreValue.Text <> "0")), 2 ), 0 )
nick9one1 353 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, that looks like it worked
nick9one1 353 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually, it looks like that hasnt fully fixed it.

When I'm in edit mode, I dont get the red error bar at the top. And if I run the monitor I dont see any errors.
After a save & publish, running the app as a normal user I see the error.
I've tried this multiple times and I have definitely published the latest version.