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