Count nos between range specified

[#1]

Hello friends !!!!

Need your help

I want to count those Dno as shown below which is ( >=-30 and <=30)

Dno	Value
1	30
2	100
3	-10
4	35
5	30
6	-26
7	20
8	16
9	-30
10	125
11	15
12	12
13	26
14	170
15	14
16	120

[sunny_talwar]

May be this:

Count({<Value = {'>=-30<=30'}>}Dno)

[miguelbraga]

Hey there,

Take the expression of stalwar1as the correct one, but if you want, make two variable like vFrom and vTo and use those into the expression like this:

= Count({<Value = {'>=$(vFrom) <=$(vTo)'}>}Dno)

This way you can have a input box to be more dinamic and practical.

Best regards,

D.A. MB

[miguelbraga]

See the attached file:

MB