I have a report with 3 groups and a details line.

 

The detail line is simply customer orders, quantities, and due dates etc.

 

The first group sorts these orders by customer.  There is a formula I've built in this group that tells us how many days until the order is due, named "Days Due":

This formula works fine.

 

The next group totals information about about the customer, and I have 10 formulas which total dollar amounts of all orders due in 1-7 days, 8-14, 15-21, 21-28, and over 28, and the same for past due 1-7 days etc.

 

An example of one of the formulas:

 

This formula is for some reason totaling all orders for the customer based on whatever the last order in the list has for @Days Due.  Here is a screenshot:

 

 

This one should have totals for 7-14, 22-28, and over 28.

 

Anyone know what's going on here?

 

Thanks!