Solved: Sum total of a duration for a given period - Page 2

Andrian_Andreev · 05-14-2020 09:20 AM

Hello,

i am working on a timesheet app. I got everything to work but my employees are asking me if they can have the sum of their working hours for the last three weeks displayed. I am really clueless of how i can pull this one.

Steve

For last week, try:

SUM(
  SELECT(
    table[Duration],
    AND(
      (USEREMAIL() = [email]),
      ([date] >= (TODAY() - WEEKDAY(TODAY()) - 7)),
      ([date] < (TODAY() - WEEKDAY(TODAY())))
    )
  )
)

For the week before that:

SUM(
  SELECT(
    table[Duration],
    AND(
      (USEREMAIL() = [email]),
      ([date] >= (TODAY() - WEEKDAY(TODAY()) - 14)),
      ([date] < (TODAY() - WEEKDAY(TODAY())) - 7)
    )
  )
)

For this week so far:

SUM(
  SELECT(
    table[Duration],
    AND(
      (USEREMAIL() = [email]),
      ([date] >= (TODAY() - WEEKDAY(TODAY())))
    )
  )
)

View solution in original post