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.

[suds144]

Dummy data attached here

[atcodedog05 · Accepted solution]

Hi @suds144 

Here is a workflow based on my understanding.

Hope this helps : )

[suds144]

Thank you! Why the Min function?

[atcodedog05]

I am using min to get a minimum of both is this logic is not correct please provide sample input and expected output.

Happy to help : ) @suds144 

Cheers and have a nice day!