Consolidate something on one time axis to another?
Updated01 Dec 2022
ByIain Morrow
The short answer is that you don’t have to. Openbox will automatically convert inputs on calculations that are on (say) a monthly basis to (say) a quarterly basis. It will also convert calculations into the basis required by the reports.
Suppose you have a model that has monthly construction, quarterly operations and financial statements that are annual. You don’t need to do any time conversion yourself – Openbox will handle it for you.
It also respects whether it is working with balances or not. If you take a monthly balance and convert to quarterly, the quarterly figure is the last monthly figure in each quarter. If it’s not a balance, the quarterly figure is the sum of the monthly figures. Openbox takes this into account when consolidating.