How to calculate the number of students who have a note>0 ?

[aminehaddar]

Hello,

I have:      studentID, note

How to calculate the number of students who have a note>0 ?

Greetings

[Anil_Babu_Samineni · Accepted solution]

May be these?

If(Sum(note)>0, Count(studentID))

OR

If(note>0, Count(studentID))

OR

Count({<note = {'>0'}>} studentID)

OR

Count({<note = {"=Sum(note)>0"}>} studentID)

[nicu1996]

=Count( {$<note={'>0'}>} studentID)