Multiple Pick Match For Colours Question

[michaelneck]

Hi All,

I am trying to create a condition on whether a certain year in the calendar is selected then an expression value (Background Colour) in a chart will be chosen. Each work individually but not nested in the if formula. Just wondering if anyone could help me out?

Thanks

=if(GetFieldSelections([Payroll Year])=$(vLastYear),

PICK(MATCH([Performance Most Recent Rating Last Year], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red)),

if(GetFieldSelections([Payroll Year])=$(vMinus2Years),

PICK(MATCH([Performance Most Recent Rating Minus2 Years], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red)),

PICK(MATCH([Performance Most Recent Rating], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red))

[sunny_talwar]

Did you miss the two closing parenthesis by mistake? Those are needed if you don't have them

=if(GetFieldSelections([Payroll Year])=$(vLastYear),

PICK(MATCH([Performance Most Recent Rating Last Year], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red)),

if(GetFieldSelections([Payroll Year])=$(vMinus2Years),

PICK(MATCH([Performance Most Recent Rating Minus2 Years], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red)),

PICK(MATCH([Performance Most Recent Rating], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red))

))

[michaelneck]

Thanks a million! Silly mistake, should have spotted it

[sunny_talwar]

No problem at all