4 Replies Latest reply on Jul 31, 2017 4:09 AM by kettan

    Revenue daily equal distribution by using start and end date of contract

    Sandra Ragues

      Hello all,

       

      I hope you can help me

       

      I have a data set with a list of contract with a start and end date. I would need to allocate the revenue equally by day by using the start and end date attribute.

       

      Example:

       

      Contract one: 30,000

      Start date: 01 Jan 2017

      End date: 20 Feb 2018

       

      I would like to distribute the 30,000 across the start and end date, most of the revenue will start in 2017 and only