1 Reply Latest reply: Jul 30, 2013 2:30 PM by Gysbert Wassenaar RSS

    Expression with WHERE and OR clause

      I am trying to create a chart with an expression where it does a count on OwnerID with a Where and OR clause.

       

      For example, i want to do a count where the [Working Status] = 'Employee' or 'Consultant'.  If I do not use the WHERE clause then the chart returns all values for Working Status (i.e. Consultant, Employee, Intern, Client, etc...)

       

      I tried using the following line of code, but it displays Consultant only.

       

      =count ({<[Working Status] = {'Employee'},[Working Status] = {'Consultant'}>} Distinct OwnerID)