What does -= mean in set analysis ?

[#1]

Hi All,

Can someone explain what the following syntax does please ? I'm confused about the -= symbols in this expression.

(sum({$<[Product Group] -= {'- Unknown}>} [Amount]))

Thanks

MV

[its_anandrjs]

In SET analysis if we talk about the <> it is known as modifiers and it is start with < and ends with > and in between this field name use to check values. But in SET analysis not equals is like (-=). For more details read the attached document related to SET analysis.

Regards,

Anand

[vikasmahajan]

<> will not work in set analysis  <> we can use in SQL Query.

vikas

[#4]

I understand what you mean as I have a red underline beneath my -= set analysis expression.

But when I tried to convert my code into your suggestion it failed. I tried a few variations but it still failed. How do I convert this line into your code

(sum({$<[Product Group] -= {'- Unknown}>} [Amount]))

[#5]

Hi,

(sum({$<[Product Group] -= {'- Unknown'}>} [Amount]))

Regards,

Joshmi

[jonathandienst · Accepted solution]

Hi

The -= is shorthand for:

Sum({<[Product Group] = {'*'} - {'- Unknown'}>} [Amount])

(ie include everything (*), but exclude '- Unknown'; or include everything except '- Unknown')

HTH

Jonathan

[#7]

Hi,

You can use <> symbol in Script but not in set analysis

[#8]

Right ! This works without any syntax errors. Many thanks for this.