Calculate hours in a week

Hey guys i want to calculate de hours on a week who do Gabriel in this table, i want to put this information in another table but i dont know as i can do it. Any ideas?

Hi @Gabriel_Luezas ,

try using

Imputación.Filter(CurrentValue.Persona que imputa = ThisRow.Usuario AND WeekNumber(CurrentValue.Fecha) = WeekNumber(ThisRow.Fecha)).Numero de horas imputadas al proyecto.Sum()

as a column formula for Horas diarias. This will summarize all hours of the person selected in Usuario during the week of Fecha.

1 Like

Yoooo, Thanks so much it works perfectrly

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.