# Reference Formula

I am trying to reference month from “Month” matrix but I am getting Syntax error

In Calculation Matrix formula :

In Forecast, Oct ..Month::Ending Month =” ”

What am I doing wrong

Hi!

Apparently, the author wanted to parametrically set the point of division of the entire calculated range (**Forecast:Month**) into two parts for two calculation algorithms.

If anyone needs to emulate in QM this behavior, try applying this formula (see below):

*

Well, then what is the specificity of the Oct..Mar range? For example, why are its values set to “space”?

The value for the Apr to Sep range can be based on some calculation nothing specific. They will be based on the requirement. This can be commission, Salary etc

Yes, the range is Apr to Sep. I am trying to create a separate matrix where I can type the name of the month that would automatically update the change

On the left side of the formula you cannot have it reference another Matrix. A formula is matrix specific. With your example what you are in effect saying is In Forecast, Oct to Matrix Month Ending Month Mar which does not make sense. Hence, a syntax error.

What I think you may be getting at is that you want Forecast to be from Oct to which ever Month is listed in Month::Month Ending, but I’m not sure.

So can you tell us what it is you are trying to do or want to accomplish?

Hi,

*

what value should be in the range Apr..Sep for the Forecast?

The range is from Apr to Sep. I am trying to find out a way to automatically set the range based on month in another matrix.

Yes the range is from Apr to Sep.

I am trying to set the range based on another matrix where I can change the month.