Reference Formula

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

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?

Answered question