how to get count for each of 3 categories? 2

[JonBartels]

I have a sales report with totals by invoice.
In the column adjacent to each total I have a formula field &quot;@ dollar range&quot; which is populated with &quot;< 1K&quot;, &quot;1K - 10K&quot;, or &quot;> 10K&quot; depending on the invoice total.
How do I get a count for each of the 3 categories?
Hope to hear from you &quot;Tek-ies&quot; soon. Thank You for your help.

 

[MalcolmW]

Paste in the text for @dollar range, it will probably be easy to modify that to do the count as well. Malcolm

 

[dcm]

JonBartels: Build yourself some Running Totals - these will enable you to accumulate the invoice value BUT only evaluate (increment) the amount if the result of a formula is true e.g. {@dollar range}=&quot;<1K&quot; etc. David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[JonBartels]

Thank you, Malcolm and David