I made some mock up data as follows (Note that I'm assuming each student would have its own row. If you need to sum the SCH Load 1/2 over multiple rows then you need to do those aggregates).
I used the following calc to get the desired effect.
IF ([Career] = 'Undergraduate' AND ([SCH Load 1]+[SCH Load 2]) < 12) THEN 'Part-Time'
([Career] = 'Graduate' AND ([SCH Load 1]+[SCH Load 2]) < 9) THEN 'Part-Time'
Please see attached workbook and I hope that helps.
Logic Calc.twbx 13.8 KB
Thank you for the response. Your mock data is just like mine. I just tried it, and it returned all students as 'full-time', which is the final ELSE. That is the result I am getting every way I try it.
I thought that the aggregation was the problem, that the computer was adding up columns of load before testing the conditions, but that doesn't seem to be the issue. First, if that was happening, all students would show as full-time, no matter what, but in my second calculation attempt, all the students were showing as part-time, which is the ELSE result.
I also tried to calculate it with just Load 1, so that there would be no aggregation
IF [Career]="Undergraduate" AND [CB SCH Load 1]<7
ELSEIF [Career]="Graduate" AND [CB SCH Load 1]<4
Again, all students showed as full-time.
This one worked:
IF [CB SCH Load 1]<12 THEN "Part-time" ELSE "Full-time" END
But if I add the career
IF [Career]="undergraduate" AND [CB SCH Load 1]<12
I expected that it would still work, but only undergrads would show, as if it had been filtered. Instead, both grads and undergrads showed, and all were full-time.
Is there anyway you can share some of your data? I'm wondering if there are blanks or something causing it not to match.
I have confidential information in the data set, so I will have to build a new workbook. Which I could, but I am going to try some workarounds first. I will come back to this eventually, because I know there has to be a way.
Thanks for you help!