Stuck with formula referencing another Matrix

Solved5.14K 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?

0

But now, I can’t seem to create a new Select statement that works for the next step. I’ve been reading and re-reading the help, and looking at the sample models without luck.

Seasonality now correctly calculates expected revenue by Year:Month
[img:1w9x74vi]http://i.imgur.com/QjewrSt.jpg[/img:1w9x74vi]

RevBreakdown is a table that shows expected breakdown into revenue types, also by Month
[img:1w9x74vi]http://i.imgur.com/KfLLMce.jpg[/img:1w9x74vi]

I now need the P&L to multiply expected Rev (from Seasonality) by RevBreakdown (for each Revenue type) to populate the Revenue lines as below (currently I have it putting all revenue into Other):
[img:1w9x74vi]http://i.imgur.com/SeLRyNm.jpg[/img:1w9x74vi]

In the P&L, I’m trying a select statement like this:

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

Latest Questions