5 Replies Latest reply on Sep 8, 2016 10:50 AM by Guilherme Lampe

    Sum Avg - Different groups of products

    Guilherme Lampe

      Hi everyone,

       

      I am having a hard time to deal with a problem with avgs. I have a large set of products, splited in different models with different acquisition values.

       

      For most of my analytics I have to use an avg value of acquisition so I can compare the rentability more properly. But as most fo you know I cannot sum the total of this average,

       

      I used a FIXED function to have the values for the group of products and it worked, but the sums of the subtotals gives me also an average, I needed to sum these subtotals.

       

      Can someone please help me with that? I send the data attached