2 Replies Latest reply on Dec 21, 2012 3:16 PM by Shawn Wallwork

    WEIGHTED MOVING AVERAGE

    Brian Smith

      WHAT IS THE SIMPLE CALCULATION FOR WEIGHTED AVERAGE.

       

      I HAVE TWO EXISTING  MEASURES, 1.) TOTAL CASES =  COUNTD(CASENUMBER) & 2.) BILLED QTY -WHICH IS PREEXISTING  FROM DATA AS TOTAL QTY UNITS BILLED FOR EACH CASENUMBER.

       

      CASES ARE SEPERATED BY LOB AND CLIENT.

       

      WHAT WOULD BE THE SIMPLE FORMULA FOR CALCULATING THE WEIGHTED AVG BILLED QTY PER CASE ? BY THE VOLUME OF CASES PER CLIENT/LOB?