Compounding Monthly Growth

Relatively new user and am struggling to build a ramping growth model based on monthly expansion.  Am using the lag function in this context:   Avg Deal Size = LAG(Avg Deal Size, -1, AEC Salesperson Assumptions.Starting Deal Size) * (1 + Deal Size Growth)   My Deal Size Growth is positive and my overall Avg Deal Size is shrinking which isn't intuitive.  Any help here would be very much appreciated.

Answers

  • Have you tried the PREVIOUS function instead? I am assuming the timescale on the module is 'Month'. 
    Avg Deal Size = PREVIOUS(Avg Deal Size) * (1 + Deal Size Growth)

  • Hi, I noticed you have a "-1" in your lag function--the LAG function is n periods in the PAST therefore -1 = +1 month ahead.  Double negative.

     

    Hi Ravi, with PREVIOUS you lose overflow, which it why LAG is desirable in this scenario.