Hi everyone!
I have the following fields:
Start date, e.g. 2017-06-12
End date, e.g. 2017-09-04
Revenue, e.g. 76,182
In the above example, the difference between the Start date and End date is 84 days. I want to divide the Revenue over the days equally and then be able to classify them into months.
So using the above example the days would be allocated as:
Jun: 18 days
Jul: 31 days
Aug: 31 days
Sep: 4 days
And the Revenue split among the days in the month in the correct ratio:
Jun: 16324.71
Jul: 28114.79
Aug: 28114.79
Sep: 3627.71
I'd also like to set the Start date as today's date every time I run the process. Finally the ability to restrict to 2 months in advance from the current month would be awesome, so the above would give results for Jun, Jul and Aug.
Many thanks in advance!
