5 Replies Latest reply on Jan 27, 2010 9:02 AM by slaglemark

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

    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