Multi Row Formula from specific value until a different specific value

[DanielCarro]

Hi Guys,

I am struggling with this Multi Row Formula which I have the following:

TEST

false

false

true

false

false

close

false

false

true

false

close

false

What i need is the following output

TEST	Result
false	false
false	false
true	true
false	true
false	true
close	false
false	false
false	false
true	true
false	true
close	false
false	false
false	false

I would appreciate any advise.

Kind Regards,

Dan

[griffinwelsh · Accepted solution]

@DanielCarro if I understand the requirement properly you can use the below formula. Example is attached as well. Please mark the thread solved if this fit your needs.

if [TEST] = "close" then "false"
elseif [Row-1:Result] = "true" then "true"
else [TEST] endif

[DanielCarro]

Hi @griffinwelsh , it worked perfectly