A dynamic distribution of the budget period onto three parts
Hi all!
We are all used to seeing in financial models the static distribution of the budget period into three parts: historical, current and forecast by grouping items of the time category:
*
*
*
Is it possible to make such reallocation parametric on the fly in QM? Below I will show a demonstration one of the methods for how to do this in QM.
See my answers below, pls.
Hi all!
*
I have attached a QM model at Tahir’s request. I think there will be no problems with understanding the calculation part of the model. All the difficulties are likely will be with trying to customize the dashboard. Unfortunately, QM has an outdated graphics engine on board. Therefore, you need to apply diligence and patience to implement the graphic idea on a canvas. The advice here is: copy the dashboard to the separate canvas, disassemble it into its component parts. Then carefully study all the settings of individual chart elements, including the chart’s expressions of elements.
*
Good luck
Mark, I’m glad you have appreciated my solution of the problem.
SAU – impressive.