Formula to aggregate data

suds144

Hi All,

I have the following input

And am trying to get the following output

I tried using the formula function
IIF(([Student in Attendance (Appts)]+[Student in Attendance (Events)])>=1)
but I keep getting an error - what am I doing wrong? Ideally, I want to combine students in attendance (appts) with students in attendance (events) if their combined score is >1. If it isn't then I want it to show 0.

atcodedog05

Hi @suds144 

Here is a workflow based on my understanding.

Hope this helps : )

Student ID.yxmd