3 Replies Latest reply on Jun 10, 2016 2:17 PM by Tina Hauser

# What is the formula for calculating the percentage of a total in real numbers?

What is the method, formula, or whatever for creating a field that reflects the real numbers for the percentage of a total? For example, in Excel it's as follows:

I have tried to create a couple of calculated fields as illustrated below, but with inaccurate results:

SUM ( [Total Population, 2010-2014] ) * SUM ( [%Penetration of Total Pop] )

SUM ( [Total Population, 2010-2014] ) * AVG ( [%Penetration of Total Pop] )

• ###### 1. Re: What is the formula for calculating the percentage of a total in real numbers?

Hi Philip!

Please see the attached workbook.

Also, here is a screenshot of the calculation:

• ###### 2. Re: What is the formula for calculating the percentage of a total in real numbers?

Thank you so very much Tina! That did the trick

• ###### 3. Re: What is the formula for calculating the percentage of a total in real numbers?

You're quite welcome, glad to help!