I have a checkbox field with 5 options. I want to generate a report that only shows records where any of these 5 checkboxes have been checked. What filter logic should I use?
I have tried using the following filter and it is not working:
[checkbox(1)] = 1 OR [checkbox(2)] = 1 OR [checkbox(3)] = 1 OR [checkbox(4)] = 1 OR [checkbox(5)] = 1