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

    Count If error

    Alwin Scheerens

      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