List Box Expression

[krishna20]

Hi Friends,

I'm having a field like TP_Type which having values POL, REN,END. I need to show these values as Policy , Renewal, Endorsement in list Box. How can i write an expression to achieve it.Please ,someone suggest to do it.

Thanks in Advance

Regards

Krishna

[tresB · Accepted solution]

Try like:

Pick(Match(TP_Type, 'POL', 'REN', 'END'), 'Policy', 'Renewal', 'Endorsement')

[krishna20]

Thank you Tresesco.

Regards

Krishna