AnsweredAssumed Answered

between in calculations

Question asked by BruceMeyers on Oct 29, 2012
Latest reply on Oct 29, 2012 by 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.

Outcomes