Forum Discussion

NOVICE02's avatar
NOVICE02
Icon for Helper III rankHelper III
6 years ago

Conditional formatting based on another table

I cannot figure this thing out and i feel that it is too simple. I have data that I direct query and have put into a table to look at month to date values by different metrics. I have created a targ...
Need Help
NOVICE02's avatar
NOVICE02
Icon for Helper III rankHelper III
6 years ago

Once I write the measure.. I choose the able and select var. penetration... which is the measure defined in:

Live_pen =

SWITCH (
TRUE (),
    ISBLANK ( [% out_liv_pen_var] ), "#BBE4EC",
    [% out_liv_pen_var] < 0 , "#DA291C" ,[% out_liv_pen_var] = 0 ,"#FFBF3F",[% out_liv_pen_var] > 0, "#00B050")

 

 

From conditional formatting i select format by field value and choose the measure that i created and click ok...

 

and nothing... am i missing a step ?