Percentage of a group

[Anonymous]

Hi, 

I feel like this might be a little more straight forward than I think and I'm overthinking it. 

I have a data set that looks something like this:

Program	application #	met standard binary
A	1	1
B	2	0
B	3	1
B	4	0
C	5	1
C	6	1
C	7	0
D	8	1

What I am looking for is the percentage of programs that are meeting the standard. So if I were to calculate for the above, 75% of programs are meeting the standard, programs A, C and D are meeting the standard. 

I believe it's a calculation but I can't figure it out

Any help that can be provided would be appreciated. 

Thanks in advance, 

Vanlang

[jameszhang0805]

@Anonymous If the standard meeting percentage is 75%, why the Program C passed, Program C just has 3 applications, and 2 applications met the standard, the meeting percentage of Program C should be 66.67%.

[Anonymous]

Hi @jameszhang0805 ,

I'm not looking for a roll up per project. 

What you calculated is absolutely correct. But what I need is a rollup of that table.

The 75% I was referring to (the number I need) is that Programs A C and D are meeting the standard at least 50% of the time. 

[amitchandak]

@Anonymous , You can get that with a measure like

divide(sum(Table[met]),count(Table[application #]))

[Anonymous]

Hi Amit,

It's not exactly what I am looking for, what I am looking for is a single calculation that will tell me that what percentage of programs made the standard, not what projects did.

Thank you though.