Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAVery clever way of filtering by summing the cell values.
I was trying to sum row tickets if they comply with the criteria. Is there a way to check if the cell is not empty? Isnumber() multiplied the other cell with -1.
Didn't know the filter used in the solution so I used 3 filters instead. 😄 Now I know how I can filter easily with this kind of data. Thanks!
My answer was wrong at first since I put salad and soup as sides too. hehe.
Here is my solution.
Finally got it right. Good practice for sum function. I have learnt to use 1 and 0 by going through some of previous solution.
It was wierd that the same formula did not work in the first go. After I restart Alteryx, it worked.
Contains([Concat_Type], "Drink") && Contains([Concat_Type], "Side") &&
(
Contains([Concat_Type], "Burger") ||
Contains([Concat_Type], "Pizza")
)