Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I assume that you need something like this:
avg(aggr(SUM(Price_for_One*Quantity)/Sum(Quantity), OfficeDimension))
- Marcus
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)
Thanks for you answer, but Why you sure that it's not a good way for the task solution?
I assume that you need something like this:
avg(aggr(SUM(Price_for_One*Quantity)/Sum(Quantity), OfficeDimension))
- Marcus
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?