Multi-row Formula Question

[kdelisi002]

Hi everyone,

I'm trying to create a mapping file based on if the TM Column has an A in it and make all the rows above that equal that output as well. So I did 

IF [TM]="A" THEN [Account] ELSE [Row-1:Mapping] ENDIF

As you can see based on the attachment it is skipping my first set of data which is making the entire output be shifted down which is wrong. I understand this is because I'm doing Row-1 and it is taking the first active row but when I try Row+1 it is saying it doesn't exist so I'm wondering if anyone knows a way around this?

[Thableaus]

Hi @kdelisi002 

How does your original data look like?

I think if you set this option to be true - "Set to Values of Closest Valid Row", it will work well.

Cheers,

[kdelisi002]

Hi, 

I tried that and it still leaves the top blank. Attached is the original data

[Thableaus · Accepted solution]

@kdelisi002 

I get what you mean. Here's an alternative:

- Add a Record ID

- Sort your data by Record ID descending (reversing the order of your data)

- Use the Multi-Row formula as you did

- Sort the data back

Cheers,

[kdelisi002]

Thanks for the help, appreciate it!

[john_miller9]

Hi @kdelisi002 ,

This looks like it produces the mapping file you were looking for.