Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any different between the following 2 formulas
1) sum({<Country = {'China','Canada'}>} Sales)
2) sum({$<Country = {'China','Canada'}>} Sales)
Thanks a lot!!
Hi,
It is pretty much the same. When the set modifier is omitted, $ is assumed.
Sean
Hi Herman,
The meaning of 2nd expression
2) sum({$<Country = {'China','Canada'}>} Sales)
Returns the sales for Country China & Canada including the current selection.
And in 1st expression
1) sum({<Country = {'China','Canada'}>} Sales)
is also same as second ,When the set to modify is omitted, $
is assumed.
Thanks all.
Just wondering....I found that some of my set expressions were added a "$" automatically while some didn't. So, i was just pizzling what's going on... I normally didn't put "$" in my expressions.