Subscribe Bookmark RSS Feed

Recursive formula for two columns

christawoodley

Community Member

Joined:

Mar 3, 2015

Hi everyone,

how to I script a recursive function to a sum column that uses itself and a neighboring column.  I attached an example... Col 2 in this example would be the one that needs a recursive-type formula. Thank you for your help. Christa

1 REPLY
Craige_Hales

Staff

Joined:

Mar 21, 2013

You can get close, like this.  The if statement in the formula deals with the lag(formulaCol) getting started without a cascade of missing values. 

8215_lag.PNG

Craige