AnsweredAssumed Answered

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

Question asked by slaglemark on Jan 27, 2010
Latest reply on Jan 27, 2010 by slaglemark

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 

 

 

Outcomes