web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Runtime error a non fi...

Power Apps

Unanswered

Runtime error a non finite number

(0) Share

Report

Report

Posted on by Sarah_cool

81

Hi

I made a calculation in a default field and it returns an non finite number.

I don't know how to solve it. If I calculate it myself, it's indeed 664561,833333333... but how do I change it to 2 decimals?

I tried the round function but that doesn't help.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

timl 37,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Sarah_cool

You can wrap your exisiting formula inside a call to Text:

Text(<InsertYourExistingFormula>, "#.00" )

Was this reply helpful? Yes No
SebS 4,824 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sarah_cool

Did You try to just wrap it in Text(num,"0.0") ? and than wrap Value() ? will look like abomination 🙂 but maybe it will work 😉

Was this reply helpful? Yes No
Sarah_cool 81 on at

Like
a
(1)

Report
Copy link

Link copied!
@SebS @timl
the text() function doesn't help, the errors stays 😞
If(And("One time" in DataCardValue4_2.Selected.Value, "2022" in DataCardValue42.Selected.Value),Value(DataCardValue21_2.Text),If(And("Contract" in DataCardValue4_2.Selected.Value, DataCardValue43.Selected.Value <= 2022,DataCardValue44.Selected.Value >= 2022), Value(DataCardValue21_2.Text)/(DataCardValue44.Selected.Value - DataCardValue43.Selected.Value +1),0))

Was this reply helpful? Yes No

Join the conversation