Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Count specific values

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
Former Member replied

Hi,

try something like this :

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

Regards,

Rogerio

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question