2 Replies Latest reply: Jan 29, 2010 12:49 PM by Julien Bruchon RSS

    Cumul inverse

      Hi all,

       

      I can't figure out how to write the right expression to get a cumul inverse, that is to say a total sum minus cumulated numbers.

      In my file, I've got customers who were billed from 0 to n months ("n" is still evolving). Thus there are X customers matching with 0 bill, Y with 1 bill ....Z with N bills .

      I'd like to see graphically the following expression:

      for month 0 = Total sum

      for month 1 = Total sum - customers Month 0

      for month 2 = Total sum - (customers Month 0 + customers month 1)

      ....

      for month N = Total sum - (customers Month 0 +.... + customers Month N-1)

       

      Thanks for your help

       

      Julien