BookmarkSubscribeSubscribe to RSS Feed
christawoodley

Community Member

Joined:

Mar 3, 2015

Recursive formula for two columns

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

Re: Recursive formula for two columns

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