Greetings! I have an Expression field in a query that sums the number of checkboxes in my table for a specific field called "Not Scored".
TotalNotScored: Sum(Abs([Requirement_Not_Scored]))
I have another Expression field that counts "Other than Satisfied" checkboxes:
TotalOther: Sum(Abs([Requirement_Other_Than_Satisfied]))
Due to some changing mission requirements, there is a scenario where both checkboxes can be checked. I need my "Not Scored" field to only count records that Other than Satisfied is not also checked. How do I tell my query to look for all Not Scored and then ignore the records that have "Other than Satisfied" also checked?
Thanks in advance