Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Varun1
Partner - Contributor III
Partner - Contributor III

Calculate cumulative time value

Hi,

I am trying to calculate the cumulative time value for the field "CycleTime" in the data given below.

Case IdentifierCycleTimeOverallTime
{F0F6B873-0000-C41D-BF1D-684552BDE75F}0 00:12:410 08:03:21
{F0F6B873-0000-C41D-BF1D-684552BDE75F}0 03:23:160 08:03:21
{F0F6B873-0000-C41D-BF1D-684552BDE75F}0 04:27:240 08:03:21
{F0CB2672-0000-C71C-950C-4DC2C310315C}0 23:04:025 21:53:37
{F0CB2672-0000-C71C-950C-4DC2C310315C}4 22:49:355 21:53:37
{F0B4C172-0000-CC1D-838E-E55D99EFAB9A}0 00:12:470 02:20:20
{F0B4C172-0000-CC1D-838E-E55D99EFAB9A}0 02:07:330 02:20:20
{F0864F72-0000-CC1B-B062-B7293AD99108}0 19:33:027 06:36:01
{F0864F72-0000-CC1B-B062-B7293AD99108}6 11:02:597 06:36:01
{F076C870-0000-CE87-BB73-11F1FFB2ADF6}5 23:43:5713 01:00:46
{F076C870-0000-CE87-BB73-11F1FFB2ADF6}7 01:16:4913 01:00:46
{F076C870-0000-C4D4-B164-AB86D7502138}19 06:10:3317 05:46:44
{F076C870-0000-C4D4-B164-AB86D7502138}26 23:36:1117 05:46:44
{F04FBE73-0000-CC1C-BBA9-3AC477F4919D}0 02:52:439 02:27:46
{F04FBE73-0000-CC1C-BBA9-3AC477F4919D}6 03:21:469 02:27:46
{F04FBE73-0000-CC1C-BBA9-3AC477F4919D}2 20:13:179 02:27:46
{F049BE73-0000-CA19-9210-73ED99172400}0 00:16:0415 03:45:39
{F049BE73-0000-CA19-9210-73ED99172400}0 00:17:2315 03:45:39
{F049BE73-0000-CA19-9210-73ED99172400}6 03:27:0315 03:45:39
{F049BE73-0000-CA19-9210-73ED99172400}8 23:45:0915 03:45:39
{E0FB2574-0000-CC12-8A93-D758F7A4B467}0 00:02:050 00:27:39
{E0FB2574-0000-CC12-8A93-D758F7A4B467}0 00:25:340 00:27:39
{E076C870-0000-C37F-B5CE-960AC1FFC18B}5 19:51:2915 12:47:50
{E076C870-0000-C37F-B5CE-960AC1FFC18B}9 16:56:2115 12:47:50

 

Here the "Case Identifier" is a repetitive value and "OverallTime" is the sum of all the "CycleTime" belonging to the same 

"Case Identifier". Is there any way to calculate the cumulative time for each case ID instead of the overall time.

Please let me know 

 

Thanks,

Varun    

1 Reply
Varun1
Partner - Contributor III
Partner - Contributor III
Author

Attached example of required output: