HELP: How to get previous row value to the new or the next row?

[tarunIMDG]

How can I achieve the Expected result as In the given data set??

The column N is calculated using the following condition -

IF             column E  is NOT NULL   OR   column F = "Rejected"  OR  column g = "Yes"

THEN      0

ELSE       [column D]+[Row-1:column N]

ENDIF

So, row 2 and row 15 gives the value as 0 which is expected but if the same condition is fulfilled again like in row 8 and row 25 then it should return the previous value of row 8 (5) and row 25 (9.48) respectively.  The new values of row 8 and row 25 should be 5 and 9.48 respectively.

[Qiu]

@tarunIMDG 
I can get the same result as your column 'N'.

Can you expain below in details

---

if the same condition is fulfilled again like in row 8 and row 25 then it should return the previous value of row 8 (5) and row 25 (9.48) respectively.  The new values of row 8 and row 25 should be 5 and 9.48 respectively.

---

For Row 8 and 25, the value for column 'Status' is 'Rejected', therefore it is zero according to your conditional statement.

[flying008 · Accepted solution]

Hi,@tarunIMDG 

I wish the flow can help you.

[tarunIMDG]

@flying008 could you please share your workflow shown above?

[tarunIMDG]

@flying008 

I tried to replicate this but it is not getting applied to all the records.  I also updated the Multirow formula to " IIF([Tile_SequenceNum]>=2, [Row-1:Field-1], [Field-1]) " but it didnt work.  Do you have any recommendations?

In the given screenshot - The same value as in Title_SequenceNum 2 should be there for 3 and 4.

[flying008]

Hi,@tarunIMDG 

Dear, your formula is right, but in the case, you need choose option "Update Existing Field" instead of "Create New Field" !

Because:

1- Update Existing Field: always get the reference value after calculate row.

2- Create New Field: only get the reference value one by one from original row.

So, you can update existing Field [Field-1] , then get expect result.

[tarunIMDG · Accepted solution]

Hello Dear @flying008 

I used the below formula to update the existing field for the missing values. 

IF [Tile_SequenceNum] = 1 THEN 0
ELSEIF [Tile_SequenceNum] > 1 THEN [Row-1:Field-1]
ELSE [Principle]+ [Row-1:Field-1]
ENDIF

Looks like it took care of my concern but still need to confirm on my larger data set. Thank you for your assistance and I will keep you posted on the thread. 😍 🤗 👍

 

[flying008]

Hi,@tarunIMDG 

So cool for your formula, maybe you can give me a like or solution? 

[tarunIMDG]

@flying008 

Yes no problem at all.😊

I have previously tagged your response as a solution to my problem. Thank you again!