1 Reply Latest reply on Jun 6, 2017 4:55 AM by Norbert Maijoor

    Equal Split Over Period

    Calvin Adams

      Hi!

       

      I have a Start date, an End date and a Revenue number. I'd like to be able to split the revenue number equally over the months between the start date and end date for each Order. For example:

       

      Order: 1

      Start date = '2017-06-06'

      End date = '2017-12-04'

      Revenue = 28,000

       

      Jun: 4000

      July: 4000

      Aug: 4000

      Sep: 4000

      Oct: 4000

      Nov: 4000

      Dec: 4000

       

      Thanks!