Skip to main content

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?

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

Reply


Terms & Conditions