I need to total negative numbers and positive numbers from the same field in a file using WRKQRY
Posted on 2006-10-24
I have GL entries in a file using a field GLAMT. GLAMT may contain a negative or positive number for each record stored in the file. Is there a way using 'Define Result Fields' to create total fields based on whether the amount field data is positive or negative.
I.E. create a field called DEBITS totaling all amounts that are positive in the GLAMT field. create a field called CREDITS totalling all amounts that are negative in the GLAMT field.
I need this pretty quick.