How to adjust the value based on Flag

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

Answered question
2


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

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

Latest Questions