3 Replies Latest reply: Jan 9, 2012 9:26 AM by david.morris RSS

    Expression - Counting Conditionally

      Hello,

       

      I have no experience of writing expressions in click view and could use a bit of help please.

       

      I have data loaded with one field called admitmethod (possible values are '1' or '2'). I have a pivot table in which I want to count another field called CRN which

      is a unique identifier for individuals, but I only want to count those with an admitmewthod of '2'.

       

      How would I write the expression for this?

       

      I have tried a few things but don't really understand the syntax. Thanks for any pointers....