6 Replies Latest reply: Jun 15, 2011 7:56 AM by Maria Martineau RSS

    Having a NOT criteria in an expression

      Hello everyone,

       

      hopefully this is a quick and easy one

       

      i've got this expression

       

      sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}, Department={'CAD','EAD'}>}amount

       

      I would like the inverse of this NOT CAD and EAD I tried this (below) but it didn't work (and a few other attemps)

       

      sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}, Department<>{'CAD','EAD'}>}amount

       

       

      any help would be greatly appreciated

       

      Thank you