2 Replies Latest reply: Jul 12, 2013 6:09 AM by Sokkorn Cheav RSS

    Statement : "Is not" / "is not equal to"

      We are trying to exclude one or more values (numeric & alpha numeric) in a set analysis, however this is not working.

      Hereunder the scripting, where we try to exclude "ProjectID 2052", which is incorrect:

       

      if(invoice_code = 'D*',

       

      sum (   {$ <  HeadAccount = {  'TO PC' , 'TO IM'  } , invoice_code = {'D*'   } , ProjectID <> { '2052' }    > } -amount )

      /

      (sum   ( {  $  <  ace_code = {  '' }  , TypeID = {'F' }   , invoice_code = {'D*'  }     >  }  uren       )/7.6)

      ,

       

      sum (   {$ <  HeadAccount = {  'TO PC' , 'TO IM'  } , invoice_code = {'H*'   }     > } -amount )

      /

      (sum   ( {  $  <  ace_code = {  '' }  , TypeID = {'F' }   , invoice_code = {'H*'  }     >  }  uren       )/8))

       

       

      How can we solve this?

      Is this the same for set analysis and general scripting in QV?

       

      Thanks in advance!