Need help in Set Analysis

[#1]

Hi

Need your help in set analysis

I have data like this

Student    StudentId       Score

Mark              1                 92
Steve             2                 10
Tim                3
May               4      
Tom               5                 60
Kim                5                   0 

Now I need to get a count of Students who have scored,(zero to be included)

I tried using set analysis,but failed.

=count({$<score<>{}>}distinct(StudentId))

Need to use set analysis in particular,not sure how to use greater than or lesser than or not equal to operators in Set Analysis .

Any help is highly appreciated in this regard

Thanks in advance

[narband2778]

Hi,

try this

Count({$<score={'0'}>}distinct(StudentId))

regards,

Naresh

[rajni_batra]

Try

=Count({<Score-={''}>}StudentId)

Regards,

Rajni

[israrkhan]

Hi use below:

for all students who have 0 or more , only empty excluded.

Count({$<Score={'*'}- {''}>}distinct StudentId)

for those who have zero

Count({$<Score={'0'}>}distinct(StudentId))

for those who are null, empty

Count({$<Score={''}>}distinct(StudentId))

[rustyfishbones]

try

=Count({<Score-={'0',''}>}StudentId)

see attached qvw

[#6]

Hi,

try this

=Count({<Score={'>=0'}>}StudentId)