not equal

[raadwiptec]

Hi

Iam trying to add an expression for not equal but does not work

Sum({<Country= {'01 '},[Sales] -= {'Insurance'}>}Values)

any suggestions

[sunny_talwar]

Have you made sure that the first part of the set analysis is not the issue here? I guess just focus on the second pary

Sum({<[Sales] -= {'Insurance'}>}Values)

This should sum all Values except for those where Sales = Insurance

[trdandamudi]

The expression looks ok to me except there is a space {'01 '}. Try as below:

Sum({<Country= {'01'},[Sales] -= {'Insurance'}>}Values)

See if this works...

[Anil_Babu_Samineni]

I am not sure, Something like below

Sum({<Country = {01}, Sales -= {"Insurance"}>} Values)

OR

Sum({<Country = {01}, Sales =- {"Insurance"}>} Values)

OR

Sum({<Country = {01}, {<Sales = {*} - Sales = {"Insurance"}>}>} Values)

[raadwiptec]

hi sunny

i just tried with this Sum({<[Sales] -= {'Insurance'}>}Values)  still it is the same .. i get values but it is wrong

basically iam trying to exclude insurance take all other categories

but if spoecify

Sum({<Country= {'01'},[Sales] = {'Leasing','X','Rent'}>}Values) - it gives me correct results. but i need to enter many categories..

[sasikanth]

Also try this,

Sum({$<Country= {'01'},[Sales] ={'*'}- {'Insurance'}}>}Values)