FinancialAnalystKid
Well-known Member
- Joined
- Oct 14, 2004
- Messages
- 779
I am working on zero balance accounts.
I have the following fields:
Class
Total Charges
Total Payments
I ran a query to get Charges and Payments from Zero Balanced accounts but now need to group it by class and have a field that shows Payments/Charges for a percentage.
I can get the data but that's for each account within a class and I want it grouped by class.
When I take out the Payment/Charges field, then I get each class listed properly with TOTAL charges and TOTAL payments. When I add the calculated field, then I get a detail with dupliate classes with each line calulating my %.
Does this make sense?
I have the following fields:
Class
Total Charges
Total Payments
I ran a query to get Charges and Payments from Zero Balanced accounts but now need to group it by class and have a field that shows Payments/Charges for a percentage.
I can get the data but that's for each account within a class and I want it grouped by class.
When I take out the Payment/Charges field, then I get each class listed properly with TOTAL charges and TOTAL payments. When I add the calculated field, then I get a detail with dupliate classes with each line calulating my %.
Does this make sense?
