6 Replies Latest reply: Sep 10, 2012 6:05 AM by Sander Janssen RSS

    Accumulate for the numerator, but regular for denominator

      How can I take the accumulation of one number and divide it by another number that is not accumulated?

       

      Month     Sold     Inventory

      Jan          5          10

      Feb          4          20

      Mar          6          15

      April          3          15

       

      So i wand to take the the Acculmated Inventory of of 60and divide it by the the April sold of 3 to get 20

       

      Thanks in Advance