How about the attached?
Using the formula:
PREVIOUS_VALUE(SUM([Number of Courses])*[Target Class Size])*(1-ZN(SUM([Attrition Rate])))
with an Advanced Compute using to sort the Years in reverse.
enrolment_what_if.twbx 72.9 KB
Thank you for your help.
After much trial and error, we were able to come up with a similar formula that seems to be working, as well as set parameters for attrition rates so in the future, our departments can change the percentages if needed.
Again, thank you!