Reference Formula

4.30K viewsFormulas and Functionsformula
0

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

braddo Posted new comment July 20, 2020

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.

1

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):
*

S A U Answered question November 15, 2019
0

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

S A U Answered question May 3, 2019
0

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

shrishank Answered question May 3, 2019
0

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

shrishank Answered question May 2, 2019
0

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?

QuantrixAuthority Answered question May 2, 2019
0

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

braddo Posted new comment July 20, 2020

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.