From what I can tell it is happening because the new field you created is based off of the days absent field which is fixed on term. So it will include term even when it isn't on the viz.
Please provide a full sample - Packaged workbooks: when, why, how
If you can't do that, you're going to need to provide more screenshots including the marks card, as well as an additional screenshot in the same layout as above but you need to include whatever dimensions you have on the color button on the marks card so we can see the granularity of the data.
Can you try with this?
IF SUM([Days Absent])>2 THEN "At Risk" ELSE "On Track" END
Thank you! That worked! I really think I need a cram course on LODs. I went to a session in Vegas and it helped, but I still don't really know what these things are doing. But this solution did work, so I appreciate you helping me over this hurdle. I'll study up on LODs here in the near future. Thanks again!
No problem. You are welcome.