Hello,
I was looking for a formula where it would distinctcount [fieldname1] and if the field [Attend] equals "absent" it would subtract one. I tried doing it several times but can't get it right. Any ideas?