1 Reply Latest reply on Nov 14, 2017 10:19 AM by Shinichiro Murakami

    Help with custom forecast calc.

    shwetha sarma

      Hello,

       

      I'm forecasting values. I will try my best to explain my requirement.

       

      I have sales data until 2017 and I want to predict sales until 2025. So, my formula for each year sale is Previous year sale value * growth factor and other parameters.

       

      Let's suppose my 2017 sale value is 398000. So, 2018 sale value based on this will be 398000 * growth factor =  2018 Sale value.

       

      2019 sale value will be 2018 sale value * growth factor parameter and so on.

       

      So for every year's sale, last year sale value has to be grabbed and multiplied with growth factor. This is why i asked for the Previous Value function or the Lookup function. Please let me know if there is a better way to do this.

       

      Year          Sale

      2017           398000

      2018          2017 Sale * growth factor

      2019          2018 sale* growth factor

      2020          2019 sale * growth factor

       

      I hope this explains better.

      Thanks!