Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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))
))
Thanks a million! Silly mistake, should have spotted it
No problem at all