Forum Discussion

zivhimmel's avatar
zivhimmel
Icon for Resolver I rankResolver I
9 years ago
Solved

Recursive calculation

Hi, How can I do the following ? First day - Column A = 100 2nd day and every day that follows, column A=yesterday's value of column A X column B.   Thanks !    
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    zivhimmel

     

    Following from other replies, you basically need to calculate the cumulative product of your 'growth factors'.

     

    Gerhard Brueckl's blog (link above) had a method using summing logarithms, then mentioned that you can now use PRODUCTX.

     

    Here are two examples using PRODUCTX in a calculated column. You could adapt this to a measure if that makes sense as well.

     

  • zivhimmel's avatar
    zivhimmel
    Icon for Resolver I rankResolver I
    9 years ago

    Thanks Anonymous, I've actually seen it before posting but couldn't extract exactly what I need from it,

    I'll give it another try.