2 Replies Latest reply on Sep 6, 2016 1:00 PM by . Berrett.Rice

# Get a percent of total with CountD as a denominator

I have a list of 21,739 distinct students. Each student has one or more goals in one of several Goal Areas. My task is to chart the Percent Of Distinct Students who have at least one goal in each of the Goal Areas. So what percent of Students has at least one goal in the area of Reading, for example.

Attached you'll find a workbook. I've calculated the number of students who have at least one goal in each of the areas, but how do I set up a table calculation that will give me the percent of total when Distinct Students is the total? It seems like I would need to use a CountD formula for the denominator for the percent of total, right? How do I do that?

I've checked the numbers in excel and there are 21,739 total unique students. So, for example, the Reading goal area should show 13,401/21,739 = 61.6%.

Can anyone help with this? Thank you!

• ###### 1. Re: Get a percent of total with CountD as a denominator

Create a new calculated field that is

SUM([Goal Area Y/N])/COUNTD([Fake Student ID])

and make the default number format percentage and you should be good to go.

• ###### 2. Re: Get a percent of total with CountD as a denominator

Thanks so much, Benjamin! That worked beautifully. I appreciate your help.