Re: SUM Time Field

HenryJS · ‎10-05-2020

Hi all,

Is it possible to SUM a Time field?

Below I have summed [Rest Time 2] but instead of correctly adding up the times it gives an incorrect time

Anonymous · ‎10-06-2020

You cannot get the sum of the time value with Groupby() table because currentgroup() is referring to the current row instead of all(table).

Try use summarize():

Table = Summarize('Engage Timesheet Export',
                  'Engage Timesheet Export'[Worker Name],
                  'Engage Timesheet Export'[Week Ending],
                  "Total Rest Time",Sumx(All('Engage Timesheet Export'),[Rest Time2]))

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HenryJS · ‎10-07-2020

@Anonymous this summarised the rest times and gave the same value for everyone - please see below

Anonymous · ‎10-09-2020

@HenryJS
I guess I misunderstood you requirement. I only see the incorrect sum time. You may add filters to set context.

Table = Summarize('Engage Timesheet Export',
                  'Engage Timesheet Export'[Worker Name],
                  'Engage Timesheet Export'[Week Ending],
                  "Total Rest Time",Sumx(All('Engage Timesheet Export'),[Rest Time2]))

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎10-05-2020

Hey there. I find that when dealing with time, it's always best to use a decimal number for times, instead of actual times; especially when adding and subtracting. My advice would be to change your time column to type number, write the measure, and then change the measure display type to h:mm:ss or if the sum is over 24 hrs, [H]:mm:ss. Should work!