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