I'm wondering if I can use Merlin 4 to predict cash flow into the future. This would be a chart similar to the Merlin 4 screenshot pasted in the previous message. But the income from each phase (entered as a negative base cost) as well as the costs, should accumulate from one month to the next. The benefit of this (vs using some other software) is that I can experiment with adjusting the timing of phases, and interactively see the impact on cash flow.
I can accomplish it using the "accumulate" checkbox after clicking the top header of the box chart. Together with a milestone for the initial cash balance, e.g. the balance on June 1.
My question is, is there a way to "reset" the accumulation, or set its starting date? The accumulate feature works well moving into the future, e.g. it's June and I can predict the cash balance in July, August, and September, starting with a milestone for the initial cash balance on June 1. But when July comes around and June is in the past, I need a way to reset the July 1 balance to the actual bank balance. I don't suppose that's possible? All I can think of is to remove all income and costs prior to July 1.
Thanks, hope that makes sense.