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.
