3 Replies Latest reply on Feb 15, 2017 12:39 PM by Norbert Maijoor

    Using Non-Aggregated and Aggregated Fields to Determine Averages

    Melissa Dymock

      I've got a data set which records every time a transaction happens with a product. Each product is classified by a model number and assigned a unique ID. Every time a transaction happens both of these are recorded.

       

      I have to determine the average profit per product by model number. I've created a count of each product sold per model (Count of Products). When I try to divide Total Profit via Count of Products, I get the warning about aggregate versus non-aggregate. I used the ATTR function to fix this but values show zero for each field. I've uploaded a truncated workbook (10.1.4) to see what I'm working with and if there's a better way. Using the straight average function doesn't appear to work because each model number and product number are listed multiple times.