Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sum Problem

Status
Not open for further replies.

equestrian

Technical User
Apr 22, 2005
37
US
I am having a problem that is about to make me crazy!!!!

We are using Crystal 10.

I took an Aged Receivables report that shows the detail and changed some things.

First, I did not want to see certain customers. So, I used the Select Expert to omit them. No problem.

Next, I changed the report so that if a customer's balance is zero or less, the report does not list the account or the open invoices. Again, no problem

Next, I changed the report so that if the total invoices that are current is greater than or equal to the customer's balance, the report does not list the account or the open invoices. Again, no problem

The previous two omission were done with the following formula in the select expert:

Sum ({vr_08610dp.DocBal}, {Customer.CustId}) > 0.00 and
Sum ({vr_08610dp.Cur}, {Customer.CustId}) < Sum ({vr_08610dp.DocBal}, {Customer.CustId})

Here's the problem. I want totals at the bottom of the report that show the total for: current, 0 to 30, 31 to 60, 61 to 90, and Total respectively. These sums include the amounts from customers whose balance is zero or less and customers whose current balance is greater than or equal to the customer's balance. The invoices are not listed on the report, but they are included in the sum.

Any suggestions??
 
I guess you want to exclude the non-group-selected records from the ranges? If so, use running totals with an evaluation formula that specifies the range. No need to add any criteria related to the group selection.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top