SOLVED

Icons based on percentage not working

Brass Contributor

I am trying to have anything that is =>100% show as green check mark icon, anything above 50% show as yellow ! icon and anything 50% or < to show as red x icon, but for some reason it's not working. It's as if it's taking into consideration the percentage from the previous cell? See attached. Hoping someone can help!! 

LisaMarie1981_1-1657125595989.png

I've tried this but doesn't work

LisaMarie1981_0-1657126448090.png

 

 

3 Replies
best response confirmed by LisaMarie1981 (Brass Contributor)
Solution
Hi Lisa,
have you tried using the following?
Value = 1, Type = Value
Value = 0.5, Type = Value
Man I feel like an idiot now, that never even crossed my mind. lol. Thanks so much!!!
no worries; I just knew the answer since I had the same problem before :D
1 best response

Accepted Solutions
best response confirmed by LisaMarie1981 (Brass Contributor)
Solution
Hi Lisa,
have you tried using the following?
Value = 1, Type = Value
Value = 0.5, Type = Value

View solution in original post