Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
BB_INTERNAL no equal to used in expression (BG_INTERNAL)
/Luis
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
Harsh,
You can try
sum({$<Client -= {"BG_INTERNAL"}>} Sales)
Nimish
Thanks Nimesh. It worked !!