14 Replies Latest reply: Apr 13, 2016 5:23 AM by Stefan Wühl RSS

    Sum of Weighted Average


      I have the following problem.

      I have a chart in QV which looks like:

      Avg.Time Total (Min.) is a weighed average which is calculated like:

      [Avg.Duration(Min.)] * [#Orders Per Activity] / [# Orders per Stage]

      Sum of Avg.Time Total (Min.) is 100.5.

      Now I want to create a Bar Chart which will show sum of Avg.Time Total(Min.) per Stage only which looks like :

      The value of this bar should be Sum of Avg.Time Total (Min.)  -  100.5.

      What formula should I use?