Create a new field in script with IF statement

[Taylorcc]

Hello, 

I am wanting to create a new field based of two current fields in my data set 

My current fields are CareClient and Focus, i would like to create the field CosNps

I am trying the below with no luck - can anyone see where i am going wrong? 

if(CareClient='Yes', 'Continuity of support',

if(CareClient='No' and Focus='Psychosocial support',
'National psychosocial support measure',

if(Focus='Clinical care coordination',
'Clinical care coordination',

'Other') as CosNps

Thank you !

[Vegar · Accepted solution]

It looks like you are missing a couple of  closing paranthesis. 

if(CareClient='Yes',

   'Continuity of support',

   if(CareClient='No' and Focus='Psychosocial support',

        'National psychosocial support measure',

         If( Focus='Clinical care coordination',

               'Clinical care coordination',

                'Other')

)) as CosNps

[Taylorcc]

That worked perfectly, thanks so much!