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
658 viewsFormulas and Functionsformula

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

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