Create new field based on blank rows of separate field

Question

Hi,

I have created a sample report for help on this issue. I am trying to create a NET NEW FIELD called "Last". A row can be considered "Last" if and only if the following row is blank. In other words, the letters in column E refer to the various steps, but there can be "A "number of steps or "N" number of steps. I need to find the LAST step which, again, is the last row before a blank.

I have tried using the multi-row formula with the following logic:

IF [row+1:Total Conversions] = "0"
THEN [Last] = "No"
ELSEIF [row+1:Total Conversions] = "1"
THEN [Last] = "Yes"
ELSE [Last]
ENDIF

The new column, "Last" is always returning 0's for every row in the file.

Does anyone know how to solve?

Alteryx Help_1.09.xlsx

MSalvage · Accepted Answer

@eu123,

I have attached an example of a multi-row formula tool that should work.

IF [Row+1:Conversions] = 1 then 'YES'
ELSE 'NO'
ENDIF

I think you may have just had the syntax a little confused.

Best,

MSalvage