Answered

Calculate % Change Between 2 Numbers and Require Comment if Outside Tolerance

(0) Share

Report

Posted on by ghutchinsMicron

152

I am trying to develop a 'New' form that reads the 'Previous' entry and calculates the % difference between the value that is entered on the new form to the previous entry. Based on that calculation, the need is to force a comment on why it is outside the tolerance.

I am rather new to PowerApps so at this point i am trying to just get the calculated difference so that I am not too overwhelmed. In my attached .jpg i would like to see the '% Diff' label equal to ... ((555 - 8888) / 8888) * 100 = -93.76 % using a statement in the 'OnChange' action for the new datacardvalue ???

When i get that I will need to force a comment if the value is greater than like %20. Hope that is clear enough to understand!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@ghutchinsMicron

For the comment, place a label on the screen to display what you want.

For the Label, simply do the calculation needed based on the values you have:

With({_enteredValue: IfError(Value(yourDataCardValue.Text), 0)}, ((yourRecord.columnName - _enteredValue) / _enteredValue ) * 100 )

assuming you have some record that you are getting your prior values from (i.e. yourRecord in the above).

Then for the label mentioned above, set the Visible property to:

IfError(Value(yourCalculatedLabel.Text), 0) > 20

That should provide what you need.

I hope this is helpful for you.
ghutchinsMicron 152 on at

Like
a
(1)

Report
Copy link

Link copied!

That was what I needed, thanks.