Count If error

alwinsch — Fri, 15 Jun 2012 13:28:15 GMT

Hi,

I use a formula in a pivot Table with the following formula: count({<[WR dienstregeling]={'Ok'}>} distinct [MW Naam])

This works perfect!

But when i want to count all values that are not 'OK', the expression gives an error...

how can i solve this?

I tried the following but it did not work

count({<[WR dienstregeling]<>{'Ok'}>} distinct [MW Naam])

I don't want to put all other values than 'OK' in my expression because there are too much values.

How do i have to count all values that are not OK?

Kind Regards,

Alwin

Re: Count If error

john_duffy — Fri, 15 Jun 2012 13:36:34 GMT

Try replacing <> with -=.

Fri, 15 Jun 2012 13:39:49 GMT

Dear,

Alwin.

for not equal set analysis you -=

count({<[WR dienstregeling]-={'Ok'}>} distinct [MW Naam]

Thanks,

Mukram