Hello everyone,
I spent countless days trying to find a workaround with no joy.
My table has multiple records, which all have multiple dates filled in on a single line.
I’d like to find a way to count the number of dates just like a rollup would do, but only the dates that are within a week. My major issue is that even though I put filters in my rollup, the output which is a sum doesn’t take each date individually, but rather does the sum of every date of the record as soon as one date is within the scope.
Any clue ?
Thank you !