if and statement syntax

Wed, 23 Oct 2013 09:46:29 GMT

hi i have the following code.

i am trying to do a lookup based on two conditions in the same statement

the first condition provides the correct data, however the second condition does not work.

could you please provide any input for syntax correction.

if(Master_Item.Subassignment= 'x',

Cost_Center_Mapping.Subassignment,

if(Master_Item.Subassignment ='x' ,

and [Bank Code] <> '',

[Bank Code]))

this is for the subassignment field name in the table

Re: if and statement syntax

bbi_mba_76 — Wed, 23 Oct 2013 09:50:48 GMT

Hi,

it seems there is a comma before the and.

if(Master_Item.Subassignment ='x' and [Bank Code] <> '',

[Bank Code]))