
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 08, 2021 10:04 AM
Hi all! Thanks in advance for any advice or help!
We’ve got the following situation:
- We have a table with a Date field, so each entry has a date
- Each entry also has a checkbox field (so checked or unchecked)
We would like to do the following:
- In another table, for each week get a sum of the number of entries in the other table that (a) occured during that week, and (b) have the checkbox checked
Does anyone know how to do this? We’ve been playing with roll-ups and counts but we can’t seem to find a solution that doesn’t require linking to every entry in the table…
Thank you!
Reply
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 08, 2021 10:13 AM
Is it an option to simply add a formula field with WEEKNUM()
to get the week number from your date field and then group on that formula field to get the numbers of record in that week? You could add a view that only show the “checked” records.
