Count specific values

[Former Member]

Hi,

I have a dimension of Age-Years(Visit) That I would like to count only if the ages fall between 19-50. I also want to divide this by the total number to get a percentile. Is there a way to have Count do this to find the number?

[Former Member · Accepted solution]

Hi,

try something like this :

Count([Age-Years(Visit)] Where ([Age] between (19,50)))

Regards,

Rogerio

[Former Member · Accepted solution]

Thanks! I knew it was something with the syntax that I was getting wrong. My system asks for a ; between the values of the between statement but it works perfect!

[Former Member · Accepted solution]

Glad to know !!!

Regards,

Rogerio