how to count student lying below a range?

[Anonymous]

Hi All,

I need an urgent help.

let say i have a slider and i want to see students lying below that selected value on the slider.Suppose i select 10% on the slider,then according to that only 3 companies are lying below that,so my question is I need this count(i.e 3) in a text box.

Anyone knows how to calculate the number of companies below the selected value on slider(it can vary and depend on user ,he/she may select 10 or 20) .

student	rank	marks	cumulative %
abc	1	756	5%
xyz	2	657	7%
def	3	454	9%
ghi	4	354	11%
jkl	5	231	12%

[#2]

This expression: "COUNT({$< [cumulative %] = {">= $(vValueInSlider)"}>} student)"

Its the COUNT of the field 'student' when the field 'cumulative%' its >= the value in the slider.

Value in slider = 10%

So If you have 3 students that have >= 10% in their corresponding 'cumulative %' field. This expression returns 3. 

I hope i've solved your problem.