Geometric Mean calculation formula

building reports webintelligence
1

I have been looking for a way to use formulas within webIntelligence to calculate “geometric mean”. Thus far I have been unsuccessful. Does anyone know a formula I can use to do this, In WebIntelligence?

Update!!
I created a formula that worked for my report, after incorporating a “LN” formula column I was able to use this =Exp(Average(Ln([LOS])/Count([LOS]))) It matches the result from Excel sheet I created that has a Geometric mean function. The only other thing I would add is to make sure you set a filter to eliminate all zeros from your results as this will cause the formula to error out.

Thank you for all your input.

katkinson :us: (BOB member since 2013-04-08)

2

Welcome to B:bob:B!

Will this help?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

I stumbled across this link and tried to apply the formula to “lengths of stay” at multiple facilities and was unable to get the calculation to work.
It is possible that by manipulating this formula in some way may work, I just have been unable to find the right outcome.

Thank you for the link though, I’m still trying to work it out.

katkinson :us: (BOB member since 2013-04-08)