((count(Select(Product[Scan],(count(Select(Product[Item],IN([Item],{“Red”}),Date([Date])=[_THISROW].[Date])))))))
Ples help me, how to solve this formula. I want to count multiple condition in Appsheet.
What are the conditions? What are examples of the data?