BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
christawoodley
Community Member

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

0 Kudos
1 REPLY 1
Craige_Hales
Staff (Retired)

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