I have the following fex code that I'm having trouble with. PRIOR to this code is executed, a portion of ECP001OUT looks like this. AFTER this code executes, a portion of ECP001OUT looks like this.

As you can see in the AFTER data, three rows were added.

However, I want only two rows to be added. I only want the total for the "deposit ticket number," not the total for the trace ID.

I think this is a problem where I have "BY TRACE_ID" but if I take it out the code fails to run. Can anyone please help?

  
TABLE FILE ECP001OUT
SUM
COMPUTE DEPOSIT_TICKET_NO_215A/A6V      = ' ';
COMPUTE CASHFLOW_NAME/A64V              = ' ';
COMPUTE TRACE_ID/A14V            		= ' ';
COMPUTE SETTLEMENT_DATE/HYYMDS          = '';
COMPUTE AGENCY/A64V                     = ' ';
COMPUTE PROCESSOR/A64V                  = 'Total Deposit Ticket: '|DEPOSIT_TICKET_NO;
COMPUTE ORGANIZATION_ID/A34             = ' ';
COMPUTE TRANS_CREATION_DATE/HYYMDS      = '';
COMPUTE TRANS_CREATION_DATE_STRING/A19V = ' ';
SUMMARY_AMOUNT/P18.2CM
SUMMARY_COUNT/P11C
COMPUTE ADJUSTED/A1V                    = ADJUSTED;
COMPUTE EXPECT_TAX_CLASS/A1V            = ' ';
COMPUTE TAXDESC_1/A64V                  = ' ';
COMPUTE TAX_AMT_1/P18.2CM               = 0;
COMPUTE TAXDESC_2/A64V                  = ' ';
COMPUTE TAX_AMT_2/P18.2CM               = 0;
COMPUTE TAXDESC_3/A64V                  = ' ';
COMPUTE TAX_AMT_3/P18.2CM               = 0;
COMPUTE TAXDESC_4/A64V                  = ' ';
COMPUTE TAX_AMT_4/P18.2CM               = 0;
COMPUTE TAXDESC_5/A64V                  = ' ';
COMPUTE TAX_AMT_5/P18.2CM               = 0;
COMPUTE TAXDESC_7/A64V                  = ' ';
COMPUTE TAX_AMT_7/P18.2CM               = 0;
COMPUTE TAXDESC_8/A64V                  = ' ';
COMPUTE TAX_AMT_8/P18.2CM               = 0;
COMPUTE SECT/I1                         = 3;
BY ALC
BY ALC2
BY DT215
BY CASHFLOW_ID
BY DEPOSIT_TICKET_NO
BY TRACE_ID
BY AGENCY_NAME
WHERE SECT EQ 1;
ON TABLE HOLD AS ECP001OUT
END
-RUN

This message has been edited. Last edited by: Fran Fitzpatrick,

Bump. Anyone have a solution?

I would assume it isn't that hard of a problem...

Solved my problem. Changed it to:

 
TABLE FILE ECP001OUT
SUM
COMPUTE TRACE_ID/A14V					= ' ';
AGENCY_NAME
COMPUTE DEPOSIT_TICKET_NO_215A/A6V      = ' ';
COMPUTE CASHFLOW_NAME/A64V              = ' ';
COMPUTE TRACE_ID/A14V            		= ' ';
COMPUTE SETTLEMENT_DATE/HYYMDS          = '';
COMPUTE AGENCY/A64V                     = ' ';
COMPUTE PROCESSOR/A64V                  = 'Total Deposit Ticket: '|DEPOSIT_TICKET_NO;
COMPUTE ORGANIZATION_ID/A34             = ' ';
COMPUTE TRANS_CREATION_DATE/HYYMDS      = '';
COMPUTE TRANS_CREATION_DATE_STRING/A19V = ' ';
SUMMARY_AMOUNT/P18.2CM
SUMMARY_COUNT/P11C
COMPUTE ADJUSTED/A1V                    = ADJUSTED;
COMPUTE EXPECT_TAX_CLASS/A1V            = ' ';
COMPUTE TAXDESC_1/A64V                  = ' ';
COMPUTE TAX_AMT_1/P18.2CM               = 0;
COMPUTE TAXDESC_2/A64V                  = ' ';
COMPUTE TAX_AMT_2/P18.2CM               = 0;
COMPUTE TAXDESC_3/A64V                  = ' ';
COMPUTE TAX_AMT_3/P18.2CM               = 0;
COMPUTE TAXDESC_4/A64V                  = ' ';
COMPUTE TAX_AMT_4/P18.2CM               = 0;
COMPUTE TAXDESC_5/A64V                  = ' ';
COMPUTE TAX_AMT_5/P18.2CM               = 0;
COMPUTE TAXDESC_7/A64V                  = ' ';
COMPUTE TAX_AMT_7/P18.2CM               = 0;
COMPUTE TAXDESC_8/A64V                  = ' ';
COMPUTE TAX_AMT_8/P18.2CM               = 0;
COMPUTE SECT/I1                         = 3;
BY ALC
BY ALC2
BY DT215
BY CASHFLOW_ID
BY DEPOSIT_TICKET_NO
WHERE SECT EQ 1;
ON TABLE HOLD AS ECP001OUT
END
-RUN