3 Replies Latest reply: Aug 5, 2013 10:03 AM by Phil Speight RSS

    Conditional Count in expression

    Phil Speight

      I have created a conditional count in an expression, however when I show this as a count in a pivot it shows it as '-1' and does not count this.  How can I count this correctly?


      My formula in my expression is below:




      ({$<[1HR Start Date]={'In Process'}>} [1HR Start Date])


      count({$<[HR Recruitment]-={''}>} [HR Recruitment])




      Although the output filters the correct records it does not count in the pivot table (last column)






      Any help appreciated