Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2010Report 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, 2010Report 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, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders