Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create and If statement that allows me to use the color expression function to color by specific year. I have come close to a solution, but not as I'd like it to be. (color codes are just examples)
This gets me a color for the first year, and all other years get the second. Its a start.
if([Service Year] = 2017, argb(255,1,149,189), argb(255,1,179,169))
What I'd like to see is:
IF([Service Year] = 2017, argb(255,1,149,189),
IF[Service Year] = '2016', argb(255,1,179,169)),
IF([Service Year] = '2015', argb(255,40,39,171)),
Etc..
Has anyone tried something similar to this?
Thanks
Try this
Pick(Match([Service Year], 2017, 2016, 2015), ARGB(255,1,149,189), ARGB(255,1,179,169), ARGB(255,40,39,171))
Try from your end and tell us how you are getting the combination of nested if statements
Try this
Pick(Match([Service Year], 2017, 2016, 2015), ARGB(255,1,149,189), ARGB(255,1,179,169), ARGB(255,40,39,171))
That worked!
Thank you!!