1 Reply Latest reply: Dec 28, 2012 6:12 PM by Erica Whalley RSS

    Calculating Weighted Average Days

      Hi -

       

      I am looking for an expression that will help me display weighted average between two different date dimensions:

       

      Monthly Report:

      Dim1. Created Date

      Dim2. Posted Date

      Dim 3. Region

      12 Month Report:

      Dim1. Created Date

      Dim2. Posted Date

      Dim 3. Region

       

      Thank you!

        • Re: Calculating Weighted Average Days

          Hi zvirina123,

           

          For me "weighted" average would suggest you have another field that holds the weightings, is this the case? If so your expression for each date would look something like

          =sum([DateField]*[Weight_Field])/sum([WeightField])

           

          Or are you trying to get the average of the created and the posted dates?

           

          Regards,

           

          Erica