Calculate Average Duration

building reports desktopintelligence
1

Hello,

I am trying to calculate an average for a series of durations - any ideas? I have seen this question posted before - but haven’t really found an answer yet.

Thanks!

ALF (BOB member since 2004-02-10)

2

A) Use the Business Objects Reporter function AVERAGE
Or
B) Create your own average using a formula such as: SUM (Total Duration) / COUNT (Nbr Cases)

Maybe, you can provide more detail regarding the problem(s) you are running into?

Andreas :de: (BOB member since 2002-06-20)

3

When trying to Select the option “Average” it is grayed out - I am unable to select it. I have tried the formula you mentioned and couldn’t get that to work either.

ALF (BOB member since 2004-02-10)

4

Your durations are probably either stored as character data, or as an actual time as in HH:MI for Hours and Minutes. In order to calculate the average of those values, you will need to convert them to a valid numeric duration (either hours or minutes as a decimal) and then do the average.

For another discussion along these lines:

Convert Seconds into HH:MM:SS

Dave Rathbun :us: (BOB member since 2002-06-06)

5

You have to be more specific: Are you trying to apply average to a measure or dimension object or a formula or?

And what exactly does not work? What formula did you try exactly? What error message, etc?

Andreas :de: (BOB member since 2002-06-20)