Hello, I have a SP List with with collum name Debut that is the date and a collumn name DurMin (time of hours that the user have worked on a task) that is number that I convert into hours and minutes, I want to have a screen with a week view with the days of the week and the sum of the hours that the user worked on the days, I would like too to see the total hours of work of the week of the user.
I don't really know how to do that I think I need to do with a group by and sum, So I have put a DataTable with two collumns and the code
AddColumns(GroupBy('MSE ATELIERS';"D_x00e9_but";"dateGroup");"SumDuree";Text(Trunc(Sum(dateGroup;DurMin) / 60) ;
"00") & ":"& Text(Trunc(Mod(Sum(dateGroup;DurMin);60));"00"))
But it just sum all the num of my collumn DurMin
