Syntax for IF AND

[ahsansalik]

Hi i am having a syntax error issue

IF [ Power] ='AC Fail' AND [RCA1] = 'Power Loss'
Then 'AC Fail Power Loss'
and if [Power]= 'AC Fail' AND [RCA1]= 'Other' Then 'AC Fail Other'
and if [ Power]='AC Fail' AND [RCA1]= 'Environmental - Weather / Storm' Then 'AC Fail Environmental - Weather / Storm'
ELSE Null()
ENDIF

[Maskell_Rascal · Accepted solution]

Hi @ahsansalik 

Change your "and if" to ELSEIF. That should make the formula work as expected. 

IF [Power] ='AC Fail' AND [RCA1] = 'Power Loss'
THEN 'AC Fail Power Loss'
ELSEIF [Power]= 'AC Fail' AND [RCA1]= 'Other' 
THEN 'AC Fail Other'
ELSEIF [Power]='AC Fail' AND [RCA1]= 'Environmental - Weather / Storm' 
THEN 'AC Fail Environmental - Weather / Storm'
ELSE Null()
ENDIF

Cheers!

Phil

[ahsansalik]

Thanks Phil 🙂