Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey
I´m new in this forum and I need your help. J
I need to get a numeric result (0,1 or 2) based on following conditions:
Field1 = Unique value
Field2= only for references that starts with 20, 40 or 45
That means:
Can you help me=?
Thank you
hello,
try this one on the formula expression of the field result:
=if(wildmatch(field2,'LCL'),'0',
if(wildmatch(field2,'20*'),'1',
if(wildmatch(field2,'40*'),'2',
if(wildmatch(field2,'45*'),'2'))))
hello,
try this one on the formula expression of the field result:
=if(wildmatch(field2,'LCL'),'0',
if(wildmatch(field2,'20*'),'1',
if(wildmatch(field2,'40*'),'2',
if(wildmatch(field2,'45*'),'2'))))
This should work too
=if(wildmatch(field2,'LCL'),'0',
if(wildmatch(field2,'20*'),'1',
if(wildmatch(field2,'40*','45*'),'2',
)))