Using % in RAG status calculation

Avinash Chandra · 03/26/23

I am trying to use % complete to indicate RAG,

Percentage complete: 75% and over "Green"

Percentage complete 50%-74% " Yellow"

Percentage complete below 49% "Red"

I am unable to use % symbol in the calculation, it gives me incorrect RAG

Kindly advise

Avinash Chandra · 03/27/23

Thanks, I am going to check and get back.

Paul Newcome · 03/27/23

Try this:

=IF([% Complete]@row>= 0.75, "Green", IF([% Complete]@row>= 0.50, "Yellow", "Red"))

Avinash Chandra · 03/27/23

Thanks, I am going to check and get back.

Avinash Chandra · 03/27/23

Thanks Paul , This works. I had forgotten this aspect. I am honoured that you answered this question of mine.

Paul Newcome · 03/27/23

Happy to help. 👍️

Best Answer