Does not =

[Anonymous]

hi, sorry if this is a very simplistic question but i've wasted all afternoon trying to figure it out.,..

i have a table in which i have the following expression:

IF (DocumentType = 'C', NetSalesValue) 

...this seems to work ok, but i also want an expression that shows everything but 'C'...

i presumed something like:

IF (DocumentType <> 'C', NetSalesValue)

...  would work but it doesnt??  what am i doing wrong? 

[Clever_Anjos]

it should work...

try IF (not DocumentType = 'C', NetSalesValue)

[Anonymous]

no that didnt work either, kind of worked for 1 or 2 lines but not all of them??

[#4 · Accepted solution]

Hi James

you can use set analysis

sum({<DocumentType =-{'C'}>} NetSalesValue)   gives everything but C

or

sum({<DocumentType =E{'C'}>} NetSalesValue)   excludes C

best regards

Chris

[Gysbert_Wassenaar]

It should work. Can you post the offending document that demonstrates the problem?

[Anonymous]

Yep, bang on - thanks