Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I think you need to use '-=' - ie:
ProjectID -= {"2052")
Hi,
You can try
sum({$<HeadAccount = {'TO PC','TO IM'} , invoice_code = {'D*'} , ProjectID -= {'2052'}>} -amount)
Regards,
Sokkorn