Forum Discussion

LCarenzo's avatar
LCarenzo
Helper I
7 years ago
Solved

Formula Help

I need a formula to return a value.   Scenario....   I have a score that is a percentage.  If the score is 99% or better it would return "Outstanding", 96% to 99% would return "Very Strong", 93% to 9...
Need Help
  • jthomson's avatar
    jthomson
    7 years ago

    It'd generally take the form of:

     

    New Measure = if([oldmeasure]>0.99,"Outstanding",if([oldmeasure]>0.96,"Very Strong",if([oldmeasure]>0.93,"Effective","Useless")))

     

    for however many levels you have

jthomson's avatar
jthomson
Solution Sage
7 years ago

It'd generally take the form of:

 

New Measure = if([oldmeasure]>0.99,"Outstanding",if([oldmeasure]>0.96,"Very Strong",if([oldmeasure]>0.93,"Effective","Useless")))

 

for however many levels you have

LCarenzo's avatar
LCarenzo
Helper I
7 years ago

Thank you!