How to adjust the value based on Flag

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


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

QuantrixAuthority Answered question February 15, 2019
You are viewing 1 out of 2 answers, click here to view all answers.

Latest Questions