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.

Answered question
1

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.