### Title

help with calculation field: if value is between x and y...

### Post

im trying to create a field that tells me: how many values in field X are between "value" and "value"

like if value is between 0 and 10... then i want the total number of instances.

my thinking is that i need two fields

1. calculation field If ( %score= "is between 0 and 10" ;1;0)

2. summary field total of above field 1.

but i cannot figure out the range part.

is there a better way?

fmpa 9, mac osx 10.5.8

thx!

-m

Try:

If ( %score ≥ Value_1 and %score ≤ Value_2 ; 1; 0)

Also consider using the function Sum ( Your_table::your_calculated_field ) instead of Summary