Hi,
I am Struggling with the Multi-Row Formula tool logic. Hope someone can help?
If the Status = 'J' then copy down J, if Status = 'P' then copy down P, Else 'R' - see below:
Thanks
Hi BarleyCorn,
This formula worked for me to replicate your results
IF [Status] = "J" then "J"Elseif [Status] = "P" then "P"Elseif [Row-1:Status] = "J" or [Row-1:Answer] = "J" Then "J"
Elseif [Row-1:Status] = "P" or [Row-1:Answer] = "P" then "P"
Else "R" Endif
Let me know how it works for you.
+Attachment
Cheers,
Cameron
Is the Ans column your expected output? I'm not understanding your required logic. Can you explain in more detail?
Chris
Hi Cameron,
Thanks for your answer. But maybe I was not clear enough. Only on column, "Ans" does not exist, its what I want "Status" to become. So if row = P, all the following rows should be P, if row = J, all following rows should = J until it comes to a new letter.
Hope this is clear?
Tom
Hi Chris,
Yes, "Ans" is where I need to go. So just one column, select "Update Existing Field" then when row = R, leave R, when row = J, all following rows = J until a new letter is display, say P, then all rows after P should be P.
Finally got your solution to work.
