Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try replacing <> with -=.
Try replacing <> with -=.
Dear,
Alwin.
for not equal set analysis you -=
count({<[WR dienstregeling]-={'Ok'}>} distinct [MW Naam]
Thanks,
Mukram