3 Replies Latest reply on Oct 29, 2012 4:33 AM by BruceMeyers

# between in calculations

### Title

between in calculations

### Post

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.

• ###### 1. Re: between in calculations

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

• ###### 2. Re: between in calculations

Case (
Number < 6000 ; 1 ;
Number < 9999 ; 2 ;
3
)