Multiple conditions in formula tool returning null values

[MHS]

Good afternoon Alteryx Community!

I have encountered an issue with the formula tool that I am hoping that someone can help me with.  I am attempting to create a new column with the formula tool which has a number of conditions to determine the status for a task.  I am running into a problem where the formula tool will apply multiple conditions to an individual row and will return a Null value (Scrubbed status column).  I believe this has something to do with the hierarchy of which conditions are applied first to the row, but am unable to eliminate the null values with changes to the statement.  Any help would be much appreciated!

Thanks, 

Matt

[markcurry · Accepted solution]

Hi @MHS it's hard to see what the issue without seeing the data. 

But 2 things to check, if is the [RunTot_Open status count] field numeric?  Is so you shouldn't have the 1 in quotes here...

IF [old_status] = "Open" AND [RunTot_Open status count] = "1" ...

Similarly for the [Sprint ready duration seconds] field, you can't use > on a string value...
ELSEIF [new_status] = "Sprint Ready" AND [Sprint ready duration seconds] > "1" ....

If that doesn't fix your issue, can you upload your 'Duration file.xlsx' file.

Hope that helps,

Mark

[MHS]

Hi Mark,

Thanks for the help on this!  Made your changes and it eliminated the nulls.

Have a good day.

Matt.