0

Count Function

I'm in the formula section and I've currently got this:

cnt('Class Pupil event attendance'.'Attended?')

I want to amend it so that it only counts if the Attended? field is Yes - just can't seem to get the right syntax.

Thanks in advance

1 reply

null
    • Ninox partner
    • RoSoft_Steven.1
    • 5 yrs ago
    • Reported - view

     Try this:

    cnt( select 'Class Pupil event attendance' where Attended = "Yes")

    Steven.