
Count occurances of a value using greater than or lesser than...
bill_robbins777 Feb 8, 2012 3:46 PM (in response to bill_robbins777)I figured it out, and thought I'd share...
The formula to get the count of values that are greater than 0, but less than or equal to 0.01 for my "Price Change" field is:
Count({< [Price Change] = {'>0<=0.01'} >} [Price Change])
The formula to get the count of values that are less than 0, but greater than or equal to 0.01 for my "Price Change" field is:
Count({< [Price Change] = {'<0>=0.01'} >} [Price Change])
The formula to get the count of values that are greater than 0.01, but less than or equal to 0.10 for my "Price Change" field is:
Count({< [Price Change] = {'>0.01<=0.10'} >} [Price Change])
The formula to get the count of values that are less than 0.01, but greater than or equal to 0.10 for my "Price Change" field is:
Count({< [Price Change] = {'<0.01>=0.10'} >} [Price Change])
The other formulae are similar. Just change the values to the range required and the operators in the middle of the formula to whatever you need.