1

I am assuming the following expression means sum of sales for year 2009 and country Sweden, but I am not sure why +1 is being used, is it used as separator or it has any special meaning?

Sum({$<Year={2009}>+1<Country={'Sweden'}>} Sales)

Stefan Stoichev
  • 4,615
  • 3
  • 31
  • 51

1 Answers1

2

1 in set analysis indicates that the calculation will ignore all selections made - returns a full set of data irrespective of user selections

In your case I can read the calculation like this:

Give me the union sum of Sales for:

  • Year={2009} - all sales for 2009. Respect the selections made (apart from Year)
  • 1<Country={'Sweden'} - sales for Sweden but as if there are no selections applied across the app (if there are any selections made - ignore them)

Helpful links:

Stefan Stoichev
  • 4,615
  • 3
  • 31
  • 51