We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Very 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.
My answer was wrong at first since I put salad and soup as sides too. hehe.
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") ||