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
-
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)) -
the code doesnt seem to work. Field not found: week at line 2
-
Sorry...
let w := yearweek(Date);
sum((select 'Table Name' where 'Week Of Year'= w).number('Working Hours' / 3600000))
Content aside
- 4 yrs agoLast active
- 3Replies
- 656Views