How Can We Help?
< All Topics

Consolidate something on one time axis to another?

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.

Leave a Reply