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:

       

       

      Count

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

      and

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

       

       

       

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

       

       

       

      1.jpg

       

      Any help appreciated

       

       

       

      Phil