View previous topic :: View next topic
|
Author |
Message |
Log Thangavel
New User
Joined: 19 Jan 2018 Posts: 18 Location: USA
|
|
|
|
Hi Team,
I have requirement to get the total of credit and debits separately in trailer using SORT
Is possible to use TOT and calculate total based on condition like
If credit then sum the data in position 10 and
If Debit then sum the data in same position 10.
The total of credit & debit should be in different position in trailer. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2023 Location: USA
|
|
|
|
Use INREC, or OUTREC with IFTHEN to create separate temporary columns for debit/credit, then use different TOTs to calculate totals separately (and use BUILD to eliminate the temporary columns in the final report, if needed) |
|
Back to top |
|
|
|