Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question regarding set analysis

Hello,

I'm very new to set analysis and have a quick question.

I was wondering what is the difference between '1' and '$' when set modifier are given as identical.

for example:

Sum({1<Year={'2013'}>}Sales)

Sum({$<Year={'2013'}>}Sales)

Based on my test, above returns the same results.

If both gives the same result, in which case do i need to use 'Sum({1<Year={'2013'}>}Sales)' rather than 'Sum({$<Year={'2013'}>}Sales)' ?

Thanks.

1 Solution

Accepted Solutions
sunny_talwar

Difference between $ and 1 will be visible once you will make selections. With  1 in your expression, any selection made won't change the result of the expression, but $ will filter out the selections and give you the results for only those elemets selected by the user. For more details on set analysis, you might want to check out the attached file.

View solution in original post

4 Replies
sunny_talwar

Difference between $ and 1 will be visible once you will make selections. With  1 in your expression, any selection made won't change the result of the expression, but $ will filter out the selections and give you the results for only those elemets selected by the user. For more details on set analysis, you might want to check out the attached file.

amit_saini
Master III
Master III

Hi,

Thanks,

AS

Not applicable
Author

Thanks for kind reply.