How to adjust the value based on Flag

3.81K viewsFormulas and Functionsformula
0

Hello,
I am trying to write a formual in consolidated matrix of the model that would pull the value from forecast matrix . So, If I out a flag in Quarter matrix say Q1=1 then it would pull Actual type value from budget matrix for type forecast in consolidated matrix.
So, attached model will have:
for Q1 Product P1 & Dept A
Actual = 8
Budget = 2
Forecast = 8

S A U Answered question February 15, 2019
2

Fortunately, QM gives us the opportunity to build the simple and clear models for problems of any complexity. But, to take advantage of this opportunity, it is necessary to learn the QM’s materiel…

S A U Edited answer February 22, 2019
2


You can do this by using IF, SELECT, and USING AS
See the attached model for your solution.

QuantrixAuthority Answered question February 15, 2019

Latest Questions

Wrap text in scripted buttons? 1 Answer | 0 Votes
Claculate product 2 Answers | 0 Votes
Sum by group in the same matrix 4 Answers | 0 Votes
Constrain input – varchar 1 Answer | 0 Votes