Forum Discussion
Solved
Store marked complete based on question
Hello, I am having trouble coming up with the solution or if its even possible. I have a client that runs multiple questions per location and as long as one is answered that store is marked...
Here is the data and the desired output. Hope this helps.
| Store | Question | Answer | Complete/Not Complete |
| 1 | New Release | Yes | Complete |
| 1 | Promotion | No | |
| 1 | Support | No | |
| 2 | New Release | Yes | Complete |
| 2 | Promotion | "Blank" | |
| 2 | Support | "Blank" | |
| 2 | Distribution | "Blank" | |
| 3 | New Release | "Blank" | Complete |
| 3 | Promotion | "Blank" | |
| 3 | Support | Yes | |
| 3 | Distribution | "Blank" | |
| 3 | Remodel | "Blank" | |
| 4 | New Release | "Blank" | Complete |
| 4 | Promotion | "Blank" | |
| 4 | Support | "Blank" | |
| 4 | Distribution | Yes | |
| 4 | Remodel | "Blank" | |
| 5 | New Release | "Blank" | Complete |
| 5 | Promotion | "Blank" | |
| 5 | Support | "Blank" | |
| 5 | Distribution | "Blank" | |
| 5 | Remodel | Yes | |
| 6 | New Release | Yes | Complete |
| 6 | Promotion | Yes | |
| 6 | Support | "Blank" | |
| 6 | Distribution | "Blank" | |
| 7 | New Release | "Blank" | Not Complete |
| 7 | Promotion | "Blank" | |
| 7 | Support | "Blank" | |
| 7 | Distribution | "Blank" | |
| 8 | New Release | "Blank" | Complete |
| 8 | Promotion | Yes | |
| 8 | Support | Yes | |
| 9 | New Release | "Blank" | Not Complete |
| 9 | Promotion | "Blank" | |
| 9 | Support | "Blank" | |
| 9 | Distribution | "Blank" | |
| 10 | New Release | "Blank" | Not Complete |
| 10 | Promotion | "Blank" | |
| 10 | Support | "Blank" |