Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Am I doing anything wrong here?
if([Product Categeory Desc]='Non Managed NFS',
if([Product Categeory Desc]='Non NFS Accounts'),[Product Categeory Desc]) as NonReccuring,
Thanks, in advance.
Should be something like:
if( [Product Categeory Desc]='Non Managed NFS', 'SomeThing' ,
if([Product Categeory Desc]='Non NFS Accounts' ,[Product Categeory Desc]) ) as NonReccuring,
Note: changes are in RED (one brace has been moved to the end)
Hi,
Not sure of the requirement here, but there is a problem in the syntax, you are missing one parameter in your second "if" statement.
if([Product Categeory Desc]='Non Managed NFS',
if([Product Categeory Desc]='Non NFS Accounts',Match_Result),[Product Categeory Desc]) as NonReccuring
Regards,
Abey
Thank you.It worked.
hi
try this
if([Product Categeory Desc]='Non Managed NFS',
if([Product Categeory Desc]='Non NFS Accounts',[Product Categeory Desc]) ) as NonReccuring,