5 Replies Latest reply on Jul 30, 2015 11:42 AM by Elodie Gbedan

    Calculate a multiple ratio

    Elodie Gbedan

      Hello

      I would like to calculate the multiple for each of the 52 weeks for data range going from 2006-2014

      Essentially the multiple formula is

       

      Multiple Sales Week N= (Sales from week N+1 to Week 52)/Week N

      So multiple for week 1= Sales week 2 to week 52/Sales week 1

       

      I suspect there might be a running sum included here, but I am not really sure of this.

       

      Thanks,

       

      Elodie