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

    between in calculations

    BruceMeyers

      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.