 |
 |
 | |
 | |
 | |
 |
|
|
| |
| |
| |
|
Last updated: 12 Jul 2002
To count the number of records that have a value within a certain range, you can use a formula like the following:
Count1 = SSum(If(Amount <= 1000,1,0))
Count2 = SSum(If(Amount > 1000 and Amount <= 3000,1,0))
Count1 will contain the number of records with values less than $1000, and Count2 will contain the number of records with values between $1000 and $3000