News and Announcements icon

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

Power Apps - Building Power Apps

Unanswered

Runtime error a non finite number

Like (0) Share

Report

Report

Posted on 3 Mar 2023 17:52:01 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:

Using Apps Using Formulas

All responses Img

All responses (3)

Answers Img

Answers (0)

Sarah_cool 81 on 04 Mar 2023 at 19:22:54

Like (1)

Report
Re: Runtime error a non finite number

@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))
SebS 4,204 Moderator on 03 Mar 2023 at 17:57:57

Like (0)

Report

Re: Runtime error a non finite number

@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 😉
timl 35,437 Super User 2025 Season 2 on 03 Mar 2023 at 17:57:54

Like (1)

Report
Re: Runtime error a non finite number

Hi @Sarah_cool

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

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