When using {1} How do i make it respect some filters?

[#1]

I am using this basic statement to get a rate for an entire region regardless of other selections

Sum

({1}CMSindx)/ Sum({1}CMSpop)

the problem is that i want the filter for date to apply I have tried everything and can't seem to make it work

would really appreciate some help.

[swuehl · Accepted solution]

If you want to clear all selection except e.g. Date field selections, I think you could use this:

= sum({1<Date=p(Date) >} CMSindx)  / Sum({1<Date=p(Date) >} CMSpop)

Regards,

Stefan