Problem calculating Time

[Anonymous]

Hi,

Please see below.  I have calculated time intervals for a particular user.

When I try and sum the times, it calculates incorrectly.  Could someone please assist.

my expression is sum(TASKTIME) And the first screenshot is just TASKTIME.

Please could you help in this regard?

i have tried changing the format to intervals in the expression, it yields a different result altogether.

Any ideas?  Thanks in advance!

[Anil_Babu_Samineni]

May be this?

sum({<USER = {'EMADIBANA564'}>}TASKTIME)

[Anonymous]

I cannot use set analysis because the calculation has to be done for a number of users.  Cannot hardset the user

[Anil_Babu_Samineni]

I am not fully understand, May be can you explain bit more. May be try this?

If(USER = 'EMADIBANA564', Sum(TASKTIME))

[Anonymous]

[sunny_talwar]

May be try this

Interval(Sum(Frac(TASKTIME)), 'h:mm:ss')

[MindaugasBacius]

Might work:

sum(distinct TASKTIME)