Multi Row Formula help!

Hi all,

I'm struggling to configure a multi-row formula tool to do the following

Requirements - whenever the word 'Box' is found in 'transactions by VAT box' column, I need the value to appear in the 'Box Number' column. E.g. for the rows in the screenshot, 'Box Number' would read 'Box 1' and then, when Box 2 appears in the 'Transactions by VAT Box' column, if would update and read box 2, and so on for box 3, box 4, box 5, box 6, box 7, box 8 and box 9.

The 'Box Number' value would continue until the next box contains is found e.g. 'Box Number' would contain 'Box 1' until 'Box 2' is found in the 'Transactions by VAT Box' column

Thanks in advance!

Transformation

Accepted answers

Try this formula:

if left([Transactions by VAT box],3)="Box" then [Transactions by VAT box] else [Row-1:Box number] endif

All comments

Hi @JamesBarzda

I believe you are expecting the below output.

Many thanks

Shanker V

Multi Row Formula help.yxmd

Try this formula:

if left([Transactions by VAT box],3)="Box" then [Transactions by VAT box] else [Row-1:Box number] endif

As a testing, have tried with huge dataset also.

Working as expected if I have in different formats too.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

Multi Row Formula help.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

Hollingsworth 335