Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
<> will not work in set analysis <> we can use in SQL Query.
vikas
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]))
Hi,
(sum({$<[Product Group] -= {'- Unknown'}>} [Amount]))
Regards,
Joshmi
Hi
The -= is shorthand for:
Sum({<[Product Group] = {'*'} - {'- Unknown'}>} [Amount])
(ie include everything (*), but exclude '- Unknown'; or include everything except '- Unknown')
HTH
Jonathan
Hi,
You can use <> symbol in Script but not in set analysis
Right ! This works without any syntax errors. Many thanks for this.