Please help me with the below if statement.

[#1]

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.

[tresesco]

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)

[abeyphilip]

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

[#4]

Thank you.It worked.

[#5]

hi

try this

if([Product Categeory Desc]='Non Managed NFS',

if([Product Categeory Desc]='Non NFS Accounts',[Product Categeory Desc]) )     as   NonReccuring,