Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
What is the difference between using =- and -= in Set Analysis?
For example: Sum({<Country=-{'Sweden'}>}Sales) and Sum({<Country-={'Sweden'}>}Sales).
Is it that -= will exclude Sweden from your selections if Sweden is selected? And =- will exclude it regardless of whether it is selected or not?
Which is the recommended option if you want to exclude Sweden?
-= will honor selection... meaning if you select India as a country....Sum({<Country-={'Sweden'}>}Sales) will show sum of just sales from India. But =- will disregard selection... meaning if you select India as Country.... Sum({<Country=-{'Sweden'}>}Sales) will continue to show the sum of sales for all countries except Sweden
EDIT: Made changes to my reply above
Hi Sunny,
The =- will not honour the selection? E.g. If I select India, it will only show the sales for India? And if nothing is selected it will show sales for all, except Sweden?
Even if you select India, it will still show sales of all the countries except Sweden.