web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Rounding numbers and f...

Power Apps

Unanswered

Rounding numbers and fixing error

(0) Share

Report

Report

Posted on by JConnelly10

Hi All,

I'm trying to divide two datacards as per the below and display the result into another one. My first question is how to round the number, where to put the round in the formula. Secondly on the load of the form I get an error saying something like the number can't be divided by 0 but the calculation does work it's just that the data card is expecting a value and doesn't get it until the user has entered some info, how can I resolve this?

If(IsBlank(DataCardValue9.Text) && IsBlank(DataCardValue10.Text), "0", (Value(DataCardValue10.Text))/(Value(DataCardValue9.Text)) *100)

thanks

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
If you want the output number to be rounded, this should be your first function. The rest you can then nest into it. The second request can be resolved by adjusting your code slightly. I would add Not() functions to only show the calculated value if both datacards contain information. Something like this:
If(Not(IsBlank(DataCardValue9.Text)) && Not(IsBlank(DataCardValue10.Text)), Round((Value(DataCardValue10.Text))/(Value(DataCardValue9.Text)) *100), 0), "0")

Join the conversation