IF Formula - For combining a combination of criteria
I'm hoping I can get some help with using an IF formula to combine a criteria.
The following three line item formulas are working correctly:
Then I have the following two line items that show what list items should be ignored.
Where I am having trouble is where I try to combine the two criteria in blue above and then still pull the data.
Here is the data:
If the data is a combination of Year 2018 and Company AU 100-517, then it should be ignored otherwise everything else should be included.
Column F and G - Should be pulling data only for 2018-100-500; 2019-100-500; 2019-100-517. But currently it is only pulling data for 2019-100-517. How can I update the formula to pick up the other two criterias?
I would continue what @Jared Dolich wrote, but add the dimension Company AU - Concat PBI with time at the year level. That way, you can now be fully scalable and be able to ignore multiple years and multiple Company AU-Concat PBI's by the checking of a Boolean.
Re: IF Formula - For combining a combination of criteria
Thank you for the suggestion about adding that dimension in and setting up a boolean. I will work on these suggestions and solutions and see what I am able to create. I will get back to you if I have any additional questions.
Would you recommend that companies be added to the same time system module or that a separate company module be built since it looks like there are going to be multiple Booleans? That way @svbhagat can reuse the time and company system modules. For example, a module that has time and products and @svbhagat only wants valid years.
If I am understanding your question correctly, it should be in the same module as it should be the same dimensionality (time at the year level by Company). Even though there could be multiple Booleans or line items, the dimensionality will be the same so there is no need for additional modules. Additionally, when another model builder "needs" this dimensionality, they should create the logic in this module instead of subsidiary view in their module. Think of it as a "store" where you will go to find goods they sell. You wouldn't go to a tire store for bread, which would be considered a subsidiary view.