Wrapping up the week with a light-hearted example - ever want to change the color scheme on the fly? nested CASE statements can get you there, along with some spaces... lots and lots of spaces padding your display values... kind of hacky but hey, who I am to complain ... :)
2 comments:
You can simplify your formula with something like:
[Order Priority]+SPACE(
case [Color Wheel]
when "Tableau" then 0
when "Sienna" then 1
when "Crisp" then 2
when "Granny Smith" then 3
when "Color Blind" then 4
end)
oh yeah! Forgot about the SPACE() function. Nice one...
Post a Comment