Rewrite Expression.

[#1]

Hi,

I have expression below

if(status=amber,yellow,

if(status=red,red,

if(ststus=green,green)))

i just want to rewrite this expression using match() or any other function just to avoid multiple if condition. please advice.

Regards,

Piyush

[tresesco · Accepted solution]

Pick( Match(status, 'amber', 'red', 'green') , 'yellow', 'red' , 'green')

Or,

If( status='amber', 'yellow' , status)

[#3]

Thanks Tresesco. i just want to know that pick expression really increases performance over multiple if conditions.

Regards,

Piyush

[tresesco]

Yes, pick-match combination is performance wise better than multiple IFs.

[#5]

Thanks for this valuable information.

[#6]

Hi tresesco,

Didn't get second expression if(status='Amber',yellow,status). could you please explain.

Regards,

Piyush.

[#7]

Hi Tresesco,

In the above expression as if(status=amber,amber,if(stautus=red,red,if(status=green,green))) but if want to insert else condition in it , then how will we deal with that in pick(match) function.

Regards

Piyush