how to use"Not equal to" in the set expression

[#1]

hi,

Could you please let me know how to use “not equal to” in the set expression.

I need to write condition OperationalCategorizationTier1!=’Batch’

I tried writing code like,

[Operational Categorization Tier 1]={*}-{‘Batch’},
[Operational Categorization Tier 1]-={‘Batch’},

It is not working. throwing error. please advise

Thanks and Regards,

Smitha

[#2]

From Help:

sum( {$<Year = Year + ({“20*”,1997} – {2000}) >} Sales )

returns the sales for the current selection but with additional selections in the field “Year”: 1997 and all that begin with “20” – however, not 2000. Note that if 2000 is included in the current selection, it will still be included after the modification.

Its working...

Karthik

[#3]

Hi Karthikeyan,

I have attached qvw for the better understanding, have commented the condition where I need use “Not equal to”. Please assist.

Thanks and Regards,

Smitha

[senpradip007]

Try this

Sum( {$<[Operational Categorization Tier 1] = [Operational Categorization Tier 1] - {'Batch'}>} YourField)

Hope it helps.

[#5]

Hi ,

Try this

[Operational Categorization Tier 1]={"*"}-{‘Batch’}

[#6]

i tried this expression and it work successfully. like this:

sum({<area-={a}>} sales)

hope it helps you

zhou