The Calc will look for NULL for a particular ClientID, If it Finds it, It will Set that ClienTID as Enrolled. In Case of 999, you have a Single value, but no NULL, so Condition Became false and It Picked up "Discharged".
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...