Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem calculating Time

Hi,

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

cap555.JPG

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

capp3.JPG

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.

capp66.JPG

Any ideas?  Thanks in advance!

6 Replies
Anil_Babu_Samineni

May be this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

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))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

CAPP999.JPG

sunny_talwar

May be try this

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

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Might work:

sum(distinct TASKTIME)