|
View previous topic :: View next topic
|
| Author |
Message |
aprak00
Warnings : 2
New User
Joined: 09 Aug 2006
Posts: 24
|
|
|
|
I need to provide the sum of an amount field based on the account number. Please find the sample below:
Data is:
| Code: |
ACCT NO POLICY CERT AMT
0001 1000 101 10.00
0001 2000 201 20.00
0001 3000 301 15.00
0002 4000 401 05.00
0002 5000 501 15.00 |
The Report should look like as follows:
| Code: |
ACCT NO POLICY CERT AMT
0001 1000 101 10.00
0001 2000 201 20.00
0001 3000 301 15.00
TOTAL 45.00
0002 4000 401 05.00
0002 5000 501 15.00
TOTAL 20.00 |
Is this possble in FOCUS. Could anyone please help me on this? |
|
| Back to top |
|
 |
rajeshramakumar
New User
Joined: 12 Apr 2007
Posts: 1
Location: Hartford
|
|
|
|
Not sure if this works <no access to test>, you might want to try
PRINT POLICY CERT AMOUNT
BY ACCT NO
ON ACCT NO SUBTOTAL |
|
| Back to top |
|
|
|
|
