Daily Revenue Split and Monthly Grouping

[CalvinA]

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!

[CalvinA]

Amazing.

Learned a lot. Thanks Nicole!