Rating based on range

(0) Share

Report

Posted on by ianallen13

282

Hello all,

I am working on a QA form update and we want to move forward with something that instead of a percentage, that the person actually gets an: Exceeds, Fully Effective, etc. (see below) based off of a % earned. Is there an easy that after the percentage score is calculated, can I have a field that says: if score is between X - X, then show "Exceeds" or something like that?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 155,764 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ianallen13 ,

You did not provide the code you use to calculate the percentage, but this would require a simple If() chain

If( Percentage >= 95, "Exceeds Expectations". Percentage >= 90, "Fully Effective", Percentage >=76, "Still Developing", "Does Not Meet Standard" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ianallen13 282 on at

Like
a
(0)

Report
Copy link

Link copied!

Apologies for not providing more info:

I have a score box field called "CU Score Box" that calculates the percentages based on errors selected.

How would I write the formula to calculate the rankings based on the percentage?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,764 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @ianallen13 ,

You would need something like this as you control value is Text, not a number

With( {wPercent: ((14-'CU_Error Count_Eval')/14)*100}, If( wPercent >= 95, "Exceeds Expectations", wPercent >= 90, "Fully Effective", wPercent>=76, "Still Developing", "Does Not Meet Standard" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ianallen13 282 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz but when I enter this, it gives me an error saying:
"Unexpected characters. The formula contains 'ParenClose' where 'CurlyClose' is expected.

I entered it just as you suggested (see below):

Any thoughts / ideas? Am I missing something?

Was this reply helpful? Yes No
ianallen13 282 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually - I just got it. Looks like the original was just missing a bracket. Got it! Thank you so much!!

Was this reply helpful? Yes No
ianallen13 282 on at

Like
a
(0)

Report
Copy link

Link copied!

Here's the final formula for anyone that may need this as an example:

With({wPercent:((14-'CU_Error Count_Eval')/14*100)},If(wPercent >=95, "Exceeds Expectations", wPercent >=90,"Fully Effective", wPercent >=76,"Still Developing","Does Not Meet"))

Was this reply helpful? Yes No