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

    Calculating percent with calculated field

    Rylan Armet



      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




      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!