Calculated grading depending on score value

[ClipperSun]

I have a rating score column and a grading column. I want to filter grade choice on the basis of the rating score.

IF  0-3     then    -  Not met KPIs / Expectation
   >3 = 5 then    - Met most KPIs / Expectation
   >5 =7  then    - Met KPIs / Expectation
   >7 <10 then   - Exceeded KPIs / Expectation
           10 then   - Far exceeded KPIs / Expectation

In the below example I want Grading to be "Met KPIs / Expectation". Thank you in advance you wonderful people.

[Nogueira1306]

You can define a var to do it

Set( varScore; NUMBER)

Then use a switch to the values

[BCLS776 · Accepted solution]

An If() statement can handle this for you. Making an assumption about the name of the rating score control:

If(
    Value(RatingScore.Text) <= 3, "Not met KPIs / Expectation",
    Value(RatingScore.Text) <= 5, "Met most KPIs / Expectation",
    Value(RatingScore.Text) <= 7, "Met KPIs / Expectation",
    Value(RatingScore.Text) < 10, "Exceeded KPIs / Expectation",
    "Far exceeded KPIs / Expectation"
)

 This statement returns a string, so it should go in the Text property of a label.

[ClipperSun]

Thank you kind sir! Worked like a charm😊