Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 96% "Effective"...... not sure how to write this.....
Solved! Go to Solution.
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
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
Thank you!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |