Stuck with formula referencing another Matrix

Solved3.36K viewsFormulas and Functions
0

I am stuck in how to create a formula that references another matrix. I think the confusing part is a time dimension that I’ve set up, based on a Quantrix Sample model.

I have a matrix P & L, with a Year dimension (2012..2016), and a Seasonality Matrix, which I use to create a Year.Month Revenue estimate.

I am trying to populate the 2015, 2016 and 2017 Month cells here:
[img:1uv8vq8l]http://i.imgur.com/xEPxhHS.jpg[/img:1uv8vq8l]

From the Seasonality matrix (below), and I just can’t seem to figure out what the formula needs to look like.
[img:1uv8vq8l]http://i.imgur.com/4yNo0kX.jpg[/img:1uv8vq8l]

Can anyone point me in the right direction?

1

You might need to link your month dimension? Right click on the month category and choose ‘Link Category’ and you will get an option to link with the other month category in the model.

Once done, the formula engine will know to rendezvous the values across the month dimension with the formulas as written.

If you don’t want categories to be linked for some reason then you will need to evaluate using a Select statement that matches the month names together. something like this.

‘4060 – Other’=select (Seasonality::’2015’,@Seasonality::Month,@Month)

But if you can rely on category linking it will do the work for you.

Hope this is helpful.

-Mike

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