2 Replies Latest reply: Feb 25, 2014 2:45 AM by Henco van Ee RSS

    Months between date and apply amount to months between 2 dates

    Henco van Ee

      Hi all,

       

      In the attached QV doc I add some example data for the question I have.

      In the document I have two dates: a startdate and an enddate. I would like to apply the total amount evenly to the months between the two dates. Like this:

       

      CustomerYearMonthAmount
      Customer X2014-02500
      Customer X2014-03500
      Customer X2014-04500
      Customer X2014-05500

       

      And so on for the other two customers in de example doc.

      I hope someone can help me with this. Thanks in advance.

       

      Kind regards,

      Henco