### Title

between in calculations

### Post

Hello, have FMP 11 advancesd

I have three parameters and am trying to calculate the number of each in a summary field.

Under 6000 Case ( Number < 6000 ; 1 ; "" )

6000 to 9999 ???

Over 10000 Case ( Number > 9990 ; 1 ; "" )

I am thinking that I have to have six fields, one each for the numbers that fall into each of the boundaries and then the summary field of each of those numbers. First, is this correct and then how do I do the calculation for 6000 to 9999?

Thank you for any help on this.

Hi Bruce,

The calculation you need is Case ( Number ≥ 6000 and Number ≤ 9990 ; 1 ; "" )

Haveing a flag for each of the boundaries and the a summary for each will give you the result your after.

Hope this helps

-- Orlando