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
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.