Multi-row formula tool not overwriting correctly

[Jack6627]

I am having some problems overwriting the results for 2 columns I created using the formula tool with a multi row tool. The original formulas are as follows:

Column_A: IIF([Position]=1,[Sent],0)

Column_B: IIF([Position]=1,[Transferred],0)

The corresponding formulas in the Multi-row formula tool are as follows:

ColumnA: IF [Position] !=1 THEN [Row-1:Column_A]+ [OQ] ELSE [Row-1:OQ] ENDIF

Column_B: IF [Position]!=1 THEN [Row-1:Column_B]+[RQ] ELSE [Row-1:RQ] ENDIF

The flow runs without errors but all the values in the two columns return 0 after the multi-row formula transformation, even when there are values in the corresponding OQ and RQ columns. All the fields are of a double data type.

Can somebody please explain why the overwrite doesn't work?

Thanks!

[Qiu]

@Jack6627 
Can you upload a sample data or your sample flow?

[Jack6627 · Accepted solution]

Hi @Qiu . Thank you for your response. There was an error in my formula and my multi-row formula tool was not placed in the right sequence!