Reference Formula

3.85K viewsFormulas and Functionsformula

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

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.


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
You are viewing 1 out of 6 answers, click here to view all answers.