Reference Formula

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
2.06K 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

Posted new comment

Notice: compact(): Undefined variable: groupby in /home/quantrixwebsite/public_html/answers/wp-includes/class-wp-comment-query.php on line 853

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.

0

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

Answered question
0

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

Answered question
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

Answered question
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

Answered question
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?

Answered question
0

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

Posted new comment

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.