2 Replies Latest reply on Nov 17, 2018 7:14 PM by ShivaRam Chennapragada

    Calculating percent with calculated field

    Rylan Armet

      Hi!

       

      I'm trying to calculate a field in order to have the percent of total.

       

      I'm working with two measures: AGG (Population) and SUM (Volunteers)

       

      My first attempt was CountD(volunteers)/population and it says calculation is valid, but then when I bring it over to my measure values it says "cannot blend the secondary data source because one or more fields use an unsupported aggregation".

       

      The population is a COUNTD of a dimension of ID numbers.

       

      I've also tried

       

      COUNTD([Volunteers])/COUNTD([Population])

       

      I need this measure so I can have percentage of participation among multiple types of fields: staff level, department, office, etc.

       

      Thanks for any and all help!

       

      Rylan