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.

Answered question

Looks interesting, please share your model.

Posted new comment

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.

You are viewing 1 out of 3 answers, click here to view all answers.