5 Replies Latest reply: Mar 14, 2018 4:21 PM by David Forest RSS

    How to count with fields = and <> to?

    Mark Jackson

      I am trying to count the number of employees using Employee No. based on location and employee category. There are a number of locations and categories. I can count the number of employees that are in 1 location and 1 category but how do I count the number of employees in 1 location and many categories or many locations and 1 category? Note: each employee will only appear in 1 location and 1 category so distinct is not required.

       

      This works

      [Main work address - Country]={'Australia'}, [ContCat]={'Employees-other'}>} [Employee no.])

       

      But this doesn't

      [Main work address - Country]={'Australia'}, [ContCat]<>{'Employees-other'}>} [Employee no.])