Syntax for not equal sign in set analysis

[#1]

Hi All,

I am trying to use set analysis which gives me the sum(sales) for all the clients except BB_INTERNAL. I tried this but got an error. Can any one help please. Thanks in advance.

sum({$<Client <> {'BG_INTERNAL'}>} Sales)

[llauses243]

Hi,

BB_INTERNAL no equal to used in expression (BG_INTERNAL)

/Luis

[#3]

Hi Luis,

Sorry it was a typo at my end. I meant BB_INTERNAL.

Corrected :

sum({$<Client <> {'BB_INTERNAL'}>} Sales)

I cant find the syntax for a not equal sign inside a sset analysis. I am not sure if this the right way to do it. Thanks

[#4 · Accepted solution]

Harsh,

You can try

sum({$<Client -= {"BG_INTERNAL"}>} Sales)

Nimish

[#5]

Thanks Nimesh. It worked !!