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?

    philip.watkinson

      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:

       

      Capture.JPG

       

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