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

[#1]

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!

[devans_1]

I think you need to use '-=' - ie:

ProjectID -= {"2052")

[Sokkorn]

Hi,

You can try

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

Regards,

Sokkorn