Multi-row formula if statement

Question

Hi -

I need to do the following - if the row above in the File name is different, I need to populate something into another column.

Input:

File NameCPC1-Feb 1-FebBC1-Feb 2-Feb 2-FebAH2-Feb 3-Feb 3-FebAA3-Feb

Output:

File NameCPC1-Feb 1-FebBC1-Feb 2-FebALL2-FebAH2-Feb 3-FebALL3-FebAA3-Feb

Basically as soon as there is a change in filename, I need the first row to say ALL in the CPC column.

thanks!

jdunkerley79 · Accepted Answer

A multi-row formula tool updating the CPC column with an expression of:

IIF([Row-1:File Name]!=[File Name],"ALL",[CPC])

should work.

You will need to make sure the CPC column is of a type which can fit ALL in (hence using a SELECT tool in the example)

vizAlter · Accepted Answer

Hi @jenner85  — Try this solution:

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.