My Opportunities have Start Date and Close Date. These are treaties. Between these dates the company makes a profit. I need to show in the report how much profit the company receives in a month and a year. But the contract can start (Start Date) in March and close (Close Date) in April. For example, I need to display exactly the profit, which turned out in April, discarding the days of profit in March. How can I do it?
My wrong decision (with this decision, unfortunately, I exclude the possibility of starting in the previous month or finishing in the next month):