Count one or first occurence to compute percentage 2

[deswalker]

Using CR10, I'm looking to determine the percent screened by age group, but the numerator should not include duplicate members with a screening.
ex.
Member AgeGroup Screened
1 6-9 yrs Y
1 6-9 yrs Y
1 6-9 yrs N
2 6-9 yrs N
3 6-9 yrs Y
3 6-9 yrs N
I need to report:
Members screened Pct.

3 2 67%

 

[lbass]

You can accomplish this by inserting a distinctcount on MemberID and then using a running total {#screened}, where you use a distinctcount of MemberID, evaluate using a formula:

{table.screened} = "Y"

reset never.

Then create a formula for the percentage:

{#screened} % distinctcount({table.memberID})

IF you are doing this at the group level, then reset the running total on change of group, and add a group condition to the distinctcount.

-LB

 

[jpdmdc]

Use 'distinct count' of members to get the total no. of members. Group on 'members' and have a formula which counts only 'Y's i.e.,
//formula
if {table.Screened}='Y' then
numbervar x:=1 else 0

then have a 'maximum' of formula by 'member' group. If it is not 0 then that means that member is screened.

 

[deswalker]

Thanks for the posts. Also I neglected to say that the report also breaks on age group. (there are many age groups)