I have a field that is called Re-Exam date. Each Re-exam date is the first of a month in a year.
I want to count the total number records of the Current Re-Exam Date (the current month), Next Re-Exam Date (Next month), and the previous month Re-Exam Date.
So let’s say a person had:
20 Re-Exams for the Re-Exam Date of 4/1/2022
14 Re-Exams for the Re-Exam Date of 5/1/2022
8 Re-Exams for the Re-Exam Date of 6/1/2022.
I can total these in a formula to 42.
And when the current month is 6/1/2022, the window shifts so I get the total of 5/1/2022, 6/1/2022, and 7/1/2022.