Problem with Avg of Avg!

[#1]

Hi, guys.

I Need your help with folowing problem.

I should to Show in KPI object (In Text Object) the avg of avg for all offices.

For the moment, I have this formula to count Avg for any office wich i choose: SUM(Price_for_One*Quantity)/Sum(Quantity).

Now I want to know, how to count Avg from this formula for all offices.

[Anil_Babu_Samineni]

I am sure, This is not right approach but try

RangeAvg((SUM(Price_for_One*Quantity)/Sum(Quantity),Avg(1))

Or

RangeAvg((SUM(Price_for_One*Quantity)/Sum(Quantity),0)

[#3]

Thanks for you answer, but Why you sure that it's not a good way for the task solution?

[marcus_sommer · Accepted solution]

I assume that you need something like this:

avg(aggr(SUM(Price_for_One*Quantity)/Sum(Quantity), OfficeDimension))

- Marcus

[#5]

I thougth about this method, too. Thanks a lot! ) But, what do think can I get the information which need vy this method? I mean Avg of Avg af all Offices?