4 Replies Latest reply: May 11, 2017 9:30 AM by Dr.Maks Clay RSS

    Problem with Avg of Avg!

    Dr.Maks Clay

      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.