Conditional Count in expression

[Anonymous]

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)

Any help appreciated

Phil

[swuehl · Accepted solution]

You've created a boolean expression, so possible results are 0 and -1 or FALSE and TRUE.

If you want to get a count of something, try like this:

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

Instead of [1HR Start Date] you might need to count another field, whatever seems appropriate to your requirements.

[Anonymous]

This worked great.  Thanks

Phil

[Anonymous]

This worked great.  Thanks

Phil