A dynamic distribution of the budget period onto three parts

2

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.

S A U Answered question February 20, 2020
3

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

S A U Posted new comment September 25, 2020

SAU – impressive.

Mark, I’m glad you have appreciated my solution of the problem.

1

Looks interesting, please share your model.

braddo Posted new comment July 20, 2020

This can be accomplished with a Category with Relative Year (Cy, Cy +1…Cy+n) a mapping matrix tying those years to actual years then a basic using as.

3

By selecting the required year as the current one, we start dynamic generation of operational data for use in financial calculations of the model.
*

*
Good luck

S A U Answered question February 15, 2020

Latest Questions