Count If error

[alwinsch]

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

[john_duffy · Accepted solution]

Try replacing <> with -=.

[#3]

Dear,

Alwin.

for not equal set analysis you -=

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

Thanks,

Mukram