I have a database that includes customers and their information, along with the total price of different orders they’ve made. I’m trying to list how many customers had the total of all their orders in different ranges (i.e.- 50 customers had orders that totaled between $5000-$7500). I made a formula to calculate the total price of all the orders from each customer, but crystal won’t let me group by my formula. At this point, I’m only able to list how many of the individual orders fell into each range, but that doesn’t give me the number of customers in each range.

 

My formula looks like this: Sum ({HORDHDR.ORDERTOTAL},{HORDHDR.CUSTNO}), where the first field is the individual order total, and the second field is the customer ID. I’ve checked the data and the formula works correctly.

I tried using running totals, but it would still only allow me to count the individual order totals, not the total of each customer's orders. I would need to use a running total based on my formula, which I can't do.

Thank you so much!

I'm counting the number of customers who had orders totalling in between 2500 and 5000, for example. If there are two customers who had orders totalling $3000.50, then I would want to count both of those customers.

Okay I see.