Reference Formula

6.60K 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

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.


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

Latest Questions