Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Wrong output caused because of BY statement
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Wrong output caused because of BY statement
 Login/Join
 
Member
posted
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,


version 7.6.10 on windows
all available formats
 
Posts: 18 | Registered: September 20, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Bump. Anyone have a solution?

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


version 7.6.10 on windows
all available formats
 
Posts: 18 | Registered: September 20, 2010Reply With QuoteReport This Post
Member
posted Hide Post
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
 


version 7.6.10 on windows
all available formats
 
Posts: 18 | Registered: September 20, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Wrong output caused because of BY statement

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.