Friday, August 26, 2011

Colour Decour

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 ... :)


Joe Mako said...

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

northwestcoder said...

oh yeah! Forgot about the SPACE() function. Nice one...