Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have struggle with this calculated field I need to make.
In first case i need to mark all rows that contains "TBC" in field Customer PO as "DUMMY-COMMITED"
In secon case i need to mar all rows that contains "DUMMY" as "DUMMY"
Rest should be marked as "COMMITED"
Is there any expression that should solve this?
l(If(WildMatch([Customer PO],'TBC'),'DUMMY-COMMITED',(IF(WildMatch([Customer Code],'DUMMY'),'DUMMY','COMMITED'))))
@MT4T As @BrunPierre mentioned you can just use his logic, or if you wanted to use wildmatch in your expression there is a slight change, please see as below:
if(wildmatch([Customer PO],'*TBC*'),'DUMMY-COMMITED',
if(wildmatch([Customer PO],'*DUMMY*'),'DUMMY','COMMITED'))
Provide any sample data to understand better
@MT4T Per your logic this simple statement in the script should work
IF([Customer PO]='TBC','DUMMY-COMMITED',
IF([Customer Code]='DUMMY','DUMMY','COMMITED') AS [Field Name]
@MT4T As @BrunPierre mentioned you can just use his logic, or if you wanted to use wildmatch in your expression there is a slight change, please see as below:
if(wildmatch([Customer PO],'*TBC*'),'DUMMY-COMMITED',
if(wildmatch([Customer PO],'*DUMMY*'),'DUMMY','COMMITED'))
Thank you, save my day. The missing "*" was an issue.