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.

S A U Answered question February 20, 2020

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.

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