1 Reply Latest reply on Nov 3, 2016 6:35 AM by lenaic.ridinger

    Cash curve dynamic

    steven breton

      Hello,

       

      i have a dataset of invoices : 3 fields : [Date Invoiced], [Date paid]  [Value]

      i would like to show a curve where absciss is a continuous date range and ordinate a sum of value.

      At each date X, i would like to sum all the [value] fullfilling [Date invoiced] < X < [Date paid].

       

      Example : date = JJ/MM/AAAA

       

      1:[01/01/2015][06/01/2015][350]

      2:[02/01/2015][07/01/2015][350]

      3:[04/01/2015][09/01/2015][350]

      4:[06/01/2015][07/01/2015][350]

      5:[06/01/2015][15/01/2015][350]

       

      Result :

      [01/01/2015] ==> [350]

      [02/01/2015] ==> [700]

      [03/01/2015] ==> [700]

      [04/01/2015] ==> [1050]

      [05/01/2015] ==> [1050]

      [06/01/2015] ==> [1400]

      [07/01/2015] ==> [700]

      [08/01/2015] ==> [700]

       

      By advance, really thank you,

       

      regards,

       

      steven