Multi Row Formula Help

[Marina_Kelner]

Hello Everyone, 

I have been trying to build a logic using multi-formula and can't figure it out for the life of me.   I have used them in the past and my current process using it as well, however i can't seem to figure out how to do something as simple as below.   

I am trying to change the value in Type (new) field, so the outcome looks like a second column (Needed Outcome).  

Basically, if there is a change in Num AND Type (new) = A or B, the next row should be A or B (based on example).  I was able to build that however it only works half way.  Can someone help please? Thank you

Num	Type (new)	Type New (Needed Outcome)
1	Possibly A	Possibly A
1	Possibly A	Possibly A
1	Possibly A	Possibly A
1	A	A
12	Possibly B	A
1	A	A
12	Possibly B	A
1	A	A
12	Possibly B	A
1	B	B
12	Possibly A	B

[CoG]

Multi-Row Formula:
IF [Num]=[Row-1:Num] || ([Num]!=[Row-1:Num] && !([Row-1:Type (new)] in ("A", "B"))) THEN [Type (new)] ELSE [Row-1:Type (new)] ENDIF

[Marina_Kelner]

Thank you Andrew, for some reason, it doesn't work.  I get the same outcome as my original Type (New) field.

I have added the same formula  you provided.

[CoG]

The only way that would be possible is if the IF condition is always true. Are "A" and "B" the actual values in [Type (new)]? If not, then that's the issue. I cannot think of anything else at the moment that could cause this problem.

[Marina_Kelner]

Andrew, you are correct!  I failed to update it properly! Uggh.. 

Thank you so much and it did work now! Thanks for bringing it to my attention!