Set analysis not working

[#1]

Hi,

can anyone tell me what I am doing wrong on the code below as it come up with a zero value when I know it should calculate a value

=sum({$<CalendarYear = {$(='2010')},Rebate_Reference = {$(='1')}>}[Sales_Value])

many thanks

Nick

[swuehl · Accepted solution]

Hi,

is there a special reason why you use dollar sign expansion for a literal within the set elements?

Try this:

=sum({$<CalendarYear = {2010},Rebate_Reference = {1}>} [Sales_Value])

I assume that CalendarYear has just integer values and also Rebate_Reference has a value 1.

Hope this helps,

Stefan

[#3]

Thanks Stefan,

much appreciated