Need to find total minutes used

[tmumaw]

avg(Session_Duration) * count(distinct upper(Authenticated_User))

I'm using the above expression to calculate home many minutes a user is using QlikView.  The Avg(Session _Duration is fine, it's when I multiply it by the number of users it gets messed up.  I have 500 users using it on avg of 10:05 minutes.

Thanks

[Vegar]

In what way is you calculation need up?

Is it an formatting error or is the calculation off?

Try to forget your expression as an interval.

Interval (avg(Session_Duration) * count(distinct upper(Authenticated_User)))

[tmumaw]

Okay.  Here is the example:  I have 506 users which use QV on an average of 10:21 MM/SS on a monthly basis.  I'm trying to get the total minutes for the month which should be 5166 minutes.

I'm using the following statement to calculate it:

(avg(Session_Duration) ) * count(distinct upper(Authenticated_User))

[Vegar]

What's the output of your expression? 3.59?

If 3,59 then you could consider your expression correct, but your
formatting wrong. Try

Interval ((avg(Session_Duration) ) * count(distinct
upper(Authenticated_User)), 'm')

[sunny_talwar]

Why don't you just do Sum(Session_Duration) to find the total duration?