Calculating Weighted Average Days

[#1]

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!

[#2]

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