Average of Percentage change

[Roberto_Licciardello]

Hi,
I need to solve my problem.

I have a table in which there are, for each single component, an old and a new price. The calculation of the percentage increase in the price is made on these two values.

However, the individual objects are grouped by categories. I'm interested in the average of the variations of the single objects, exposed without showing every single object. But if I remove the object column, the table makes the percentage change of the averages and not the average of the percentage change.

I am attaching the images of what I say and an example excel

thank you.

[Or]

Perhaps something along the lines of:

Avg((New/Old)-1) would work? What formula are you currently using?

[Roberto_Licciardello]

Hi,

the formula is (avg(New)-avg(OLD))/avg(OLD). 

The problem is that i want to have  1,86 % (the average of the percentage) but the table, if i hide the column "ID object", returns 2,07 (that is the percentage of the average).

[Or · Accepted solution]

If each of your items has one row of data, the formula I suggested should work. You could also phrase it as:

Avg((New-OLD)/OLD)

If each one has multiple rows of data, I think you  may need aggr() here, perhaps:

avg(aggr((avg(New)-avg(OLD))/avg(OLD),[ID Object]))

[Roberto_Licciardello]

WONDERFUL!!! It works!!!

GRAZIE!!!