Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASimilar solution
if (!IsEmpty([CountWithNulls_Pizza]) or
!IsEmpty([CountWithNulls_Burger]))
and
(!IsEmpty([CountWithNulls_Side])
AND
!IsEmpty([CountWithNulls_Drink]))
then
1
else
0
endif
Thanks,
Siva
I interpreted "Since June" to include the period of June. Easy enough to change my date filter after seeing my final answer didn't match the output tab...