I'm looking at this. Are you trying to get, for example, the 69% in the 8th year for Fall 2008 not to display? Or the 63% in 7th year of Fall 2010?
How does it happen that there is a Total Number Enrolled in the 8th year of Fall 2009 when there was nothing in the 7th year? Is that legitimate?
I'm trying to determine a condition that guarantees when something should be null without having to reverse engineering all the table calcs in your sheet. At a visual glance it might be that those table calcs should be null when there is no value for Total Number Enrolled.
For your first question, it would be both.
I need to explain further. You are correct in that the 8th year has passed for Fall 2008 cohort, but we wanna leave it blank since they're were no changes the prior year.
For your second question, a student can come back and enroll if they did not attend the previous year. It's few and far between, but we can detect it on this dashboard.
Hopefully that helps!
So am I correct in what I said at the end of my first post? " At a visual glance it might be that those table calcs should be null when there is no value for Total Number Enrolled."
I modified your [Graduation %] calc to this:
not ISNULL([Total Number Enrolled]) then
It fixed all those spurious values. But it also eliminated all the places where the value showed up as 0% (such as all the ones in "First Year".) It's far simpler than all the conditions and previous_values and all that you had originally.
Wow! Thanks so much for your time and help Joe!
I made it too complicated lol.