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] )