i have a table that i would like to calculate only if YEAR is not selected.
Which is the right syntax?
If(not getselectedcount(YEAR), <expression>)
Update: ohh,, you wanted otherwise (corrected adding a 'not')
You might also be able to do this in your expression
If(GetSelectedCount(YEAR) = 0,....)
Or use this in chart's calculation condition like this
GetSelectedCount(YEAR) = 0
Retrieving data ...