What's your calc?
IF ISNULL(Training) AND NOT ISNULL(Year of Start Date) THEN COUNTD(ID) END
If this doesn't work please attach a workbook.
Got a cannot mix aggregate and non-aggregate with IF. I attached a packaged workbook.
Thanks Shiva. I think we are close. Properly counting 640 of 645 records. Check out record 148872 (sheet 1). I would like that to return a positive result.
(this is why I was thinking this might be an LOD calc. Because the 5 missing instances have this same setup. Where the IDU in question did receive training, but in a different quarter than their service start date. So, the Tableau calc needs to take into consideration all 4 quarters/rows of data for each IUD.) ~ Hope that helps! (I'm still trying on my end.)