This content has been marked as final. Show 2 replies
1 of 1 people found this helpful
You need to use calculated fields something like
IF [percentage] >= 99 THEN 'green'
ELSEIF [percentage] >= 97 AND [percentage] < 99 THEN 'Yellow'
All the best,
Works like a charm!