0

I have a formula that shows me hours worked for an individual day, I want to make it so that these are all added up for each week from Monday to Friday showing me the total hours worked that week.

I have a formula that shows me hours worked for an individual day, I want to make it so that these are all added up for each week from Monday to Friday showing me the total hours worked that week.

3 replies

null
    • Nick
    • 3 yrs ago
    • Reported - view

    First, create a formula field e.g. Week Of Year;

    yearweek(Date).

     

    Then create another formula field e.g. Week Hours:

    let w := yearweek(Date);
    sum((select 'Table Name' where Week = w).number('Working Hours' / 3600000))

    • Higginson Entertainment
    • James.2
    • 3 yrs ago
    • Reported - view

    the code doesnt seem to work. Field not found: week at line 2

    • Nick
    • 3 yrs ago
    • Reported - view

    Sorry...

    let w := yearweek(Date);
    sum((select 'Table Name' where 'Week Of Year'= w).number('Working Hours' / 3600000))

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 656Views