Hai,
I am keeping all the data at district level. I need to know the count of districts having value less than Nation value.
I am keeping nation value in one variable.
I need count of distinct district having the value less than nation,
For example
My district values are
Dis1 - 20
Dis2 - 40
Dis3 - 15
Dis4 - 22
Dis5 - 21
Dis6 - 35
My nation value is vNation=25
So I need count(District)= 4
Please tell me the expression for finding count compare with some value..
And also I need the list of districts having lesser value compare with nation
ex:- Dis1, Dis3, Dis4, Dis5
Thanks,
Sibin Jacob.C