Urgent help

[Kiara16]

Hi 

i have two columns tax year and period

i want to make a new column month by attached logic.

can someone tell me whats the error in this? I am getting timeout error. And getting null values in the output.

[Dev73]

Hi @Kiara16 can you send the screenshot of the error?

[Qiu]

@Kiara16 
Most likely that your "tax year" and "period" are of Numeric Data type, and you should remove the quotes around 2022 and same for 9, 10, 11, 12

And your current result should be empty rather than null, right?

If [Tax Year] = 2022 and [Period]=9 then "March" elseif
[Tax Year] = 2022 and [Period]=10 then "April" elseif
[Tax Year] = 2022 and [Period]=11 then "May" elseif
[Tax Year] = 2022 and [Period]=12 then "June" else
" " endf

[Kiara16]

This is the error

[Kiara16]

For the one where criteria is met its showing  NULL

and also when i am removing quotes its coming in black

[JyotsnaMalik3139]

Try removing quotes and put months in the single quotes

[Kiara16]

Thank you all i got that sorted. Got my mistake