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.
Hi @Kiara16 can you send the screenshot of the error?
@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
This is the error
For the one where criteria is met its showing NULL
and also when i am removing quotes its coming in black
Try removing quotes and put months in the single quotes
Thank you all i got that sorted. Got my mistake
