AnsweredAssumed Answered

Count empty portal fields

Question asked by ahamel on Sep 25, 2017
Latest reply on Sep 26, 2017 by beverly

I am collecting data on classes attended for students. I need to separate out the folks who have classes listed, but have not attended yet from those who have attended all their classes. For example a person could have a "yes" or "no" for attendance, but they could also have a blank field because that the class hasn't happened yet. Ideally, I want to find all the folks with no "no"s  and no blanks. I have the portal set up from an Enrolled Table. The classes are from a Classes table and the students are from a Students table. Attendance is recorded in the Enrolled Table. I know this must be possible. In Excel I would use a CountIf formula, but I can't seem to figure it out here. Bit of a newbie.

Outcomes