Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
One question, i have the following if:
if(Field1=Valuex1,
if(Field2=Valuey1, Expression,
if(Field2=Valuey2,Expression,
if(Field2=Valuey3,Expression,
if(Field1=Valuex2,
if(Field2=Valuey1, Expression,
if(Field2=Valuey2,Expression,
if(Field2=Valuey3,Expression
))))))))
I want to use pick match instead of that big if (it is even bigger)
Any ideas?
Thanks in advance
What about something like this?
Pick(Match(Field1&'|'&Field2, 'Valuex1|Valuey1', 'Valuex1|Valuey2' , 'Valuex1|Valuey3', 'Valuex2|Valuey1', etc...), Exp11, Exp12, Exp13, Exp21, etc...)
What about something like this?
Pick(Match(Field1&'|'&Field2, 'Valuex1|Valuey1', 'Valuex1|Valuey2' , 'Valuex1|Valuey3', 'Valuex2|Valuey1', etc...), Exp11, Exp12, Exp13, Exp21, etc...)