calendar as data island

[m_woolf]

I have a master calendar that is not linked to nay other table.

In my expression, I use something like:  =sum(if(field1 = calendar_field1,field_to_sum))

This works, but I believe that if I could replace it with set analysis it would be faster.

Any help?

[ogster1974]

SUM({$ <[field1]=p([calendar_field1])>} field_to_sum) should work

[m_woolf]

I thought that I tried that, but I tried again and it worked.  Thanks.

[ogster1974]

No problem glad I could help. 

[chrisjad]

How do you handle an AVG function with calendar Island?

For example, if a create a KPI to return an average of sales using the date from the calendar island, what would be the formula?