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

Question

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 Answer

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,