set analysis question

[#1]

How do I write this set analysis?

The one I have now counts how many inforequest there are (per city) divided by the population of a certain city

For this the next expression works.

count(DISTINCT inforequest_id)/NullCount(total Inhabitant_until)

Now I want to add a set analysis.

Because when I select a month/quarter/year the the expression changes aswell.

So I did the next:

count(DISTINCT inforequest_id)/NullCount(total {1}Inhabitant_until)

which worked fine to disregard the selections I made.

But the problem is that is should take into account the selected city.

How do I write in the expression that the city should equal the selected city

but disregard all the other selections that are made.

Kind regards,

Katleen

[gmoraleswit]

try this:

count(DISTINCT inforequest_id)/NullCount(total {1<city=P(city)>}Inhabitant_until)

[#3]

Gives me a few 1000%, so it doesn't work unfortunatly