Creating a new field based on other field (quarter-year)

[Srini96]

IF [Quarter closed] = 'Q4-2019' OR [Quarter closed] = 'Q1-2020' OR [Quarter closed] = 'Q2-2020'
THEN '1'
ELSE '0'
END

I'm trying to implement this and it's giving me a parse error. Can someone let me know how to go about this?

Thanks 

[Thableaus · Accepted solution]

Hi @Srini96 

You need to finish your IF clause with ENDIF

IF [Quarter closed] = 'Q4-2019' OR [Quarter closed] = 'Q1-2020' OR [Quarter closed] = 'Q2-2020'
THEN '1'
ELSE '0'
ENDIF

Cheers,

[Srini96]

Thank you! That worked