2 Replies Latest reply: Jun 15, 2012 9:36 AM by John Duffy RSS

    Count If error

    Alwin Scheerens



      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,