Forum Discussion
gopichilla
Resolver III
Resolver IIIHow to solve this one
I want sales ranges in colors like below sales between 60% to 100% - green sales between 35% to 59% -yellow sales below 35% -red Thanks
Thanks for quick response.
I got a solution for my question below is my solution
Sales Range = IF(Sales[Sales]<1000,"low",IF(Sales[Sales]<3000,"medium","high"))
Yep, that will work!
Greg_Deckler
Community Champion
Community Champion% of what, or are those like 1,519.9% (first one)?
gopichillaThanks for quick response.
I got a solution for my question below is my solution
Sales Range = IF(Sales[Sales]<1000,"low",IF(Sales[Sales]<3000,"medium","high"))
- Greg_Deckler
Yep, that will work!