In a report I have two columns that mean the same thing just labeled differently. Example:

Col 1: TRANSFER
Col 2: Transfer In

How would I make virtual field to keep a sum of when one of these col are encountered? I am using this in an across on my report. Thanks for the help.

This message has been edited. Last edited by: Kerry,

I am not sure if i understand your question correctly; from what i understand, you can try this code

 
DEFINE FILE .......
Col/I1 = IF Transfer_Field EQ 'TRANSFER' THEN 1 ELSE IF TRansfer_Field EQ 'Transfer In' In THEN 1 ELSE 0

So on that way if you keep tack of how many time those label were uses.

To find out the total number of time those fields were use you can simply use

 TABLE FILE....
PRINT....
ON TABLE COLUMN-TOTAL AS 'Sum of transfer Field use' 

Thank you I will have to try this.