Set Analysis Problem

[#1]

Hello,

I am using IF condition but not able to use 'DOES NOT CONTAIN' i.e '<>' sign in the set analysis.

IF CONDITION

==>> sum(if(@WS <>'R' and @WS<>'I' ,#QUANTITY/1000))

I need to implement above condition in the set analysis (FROM and TO)

===> IF(@WS<>'R' or @WS<>'I' ,SUM({<%DATE ={">=$(vFrom) <=$(vTo)"} >}#Quantity)/1000)

Need Help...!!!

[Gysbert_Wassenaar]

Try: SUM({<@WS-={'I','R'} %DATE ={">=$(vFrom) <=$(vTo)"} >}#Quantity)/1000)

[sunny_talwar]

Another option could be:

=Sum({<@WS = e({<@WS = {'I','R'}>}) %DATE = {">=$(vFrom) <=$(vTo)"} >} #Quantity) / 1000)

Best,

Sunny

[#4]

IT IS NOT WORKING.....!!!!

[sunny_talwar]

Does this work?

SUM({<@WS-={'I','R'}>}#Quantity)/1000)

If it does, then problem would be in this part -> %DATE ={">=$(vFrom) <=$(vTo)"}

Best,

Sunny