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

    Calculate a multiple ratio

    Elodie Gbedan


      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.