Combination of Values

siva_boggarapu — Sat, 16 Nov 2024 00:31:36 GMT

Hi Team,

I have requirement like below

1 one
2 two
3 three
4 four
5 five
update
No update

I need to create one filter like

If -1 one,2 two,3 three---10+

if - 2 two,3 three-20+

If -3 three, 4 four, 5 five-30+

Please let me know how I can write expression and I am trying like below expression. But its not giving 20+

if(Match(filed,'1 one','2 two','3 three') ,'10+',
if( Match(filed,'2 two','3 three'),'20+'))

Regards,

Siva

topic Combination of Values in Integration, Extension & APIs