- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 16, 2024 06:25 AM
Context:
I have two different tables: A User Info table, and an Event Request table. the relevant columns User Start Date, Event Start Date and Event End Date.
Current Status:
I am calculating the duration of the events in the Event Request table, pulling it into the User Info table and summing it to calculate total event duration per user.
Issue:
I want that event duration to reset after passing anniversaries of the user's start date. Any thoughts?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 16, 2024 06:59 PM
Hmm, perhaps try pulling the User Start Date into the Eent Request table, then create a formula field that checks whether that event is before the current anniversary? Then update the field that calculates the duration to account for this new formula field and output 0 if it is
