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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] hi
 Login/Join
 
tsantosh
Member
posted
In a hold file i have FEE_RETL_AM which has values based on the product code.I have two product codes 001 for visa and 002 for master.
Now i want to print FEE_RETL_AM as a by field in the final reporting file in which i should have both visa discount(001) and master discount(002).
I am looking at the output of the hold file and i can see results for both 001 and 002.But while printing in the final table file i am getting diffrent values when i look at results.
I used this code to print that
DEFINE FILE HOLDFILE1
MC_disc= IF PRDT_CD EQ '002' THEN FEE_RETL_AM ELSE 0 ;
VISA_disc= IF PRDT_CD EQ '001' THEN FEE_RETL_AM ELSE 0 ;
END
TABLE FILE HOLDFILE1
SUM
TOTTXN AS 'NET TRANSACTIONS'
TOTVOL AS 'NET SALES'
CB_TRAN_CT AS 'CHARGEBACK TRANSACTIONS'
US_CB AS 'CHARGEBACK SALES'
BY BANK_ROOT AS 'MERCHANT GROUP'
BY OTLT_CNCY_CD AS 'CURRENCY CODE'
BY OTLT_ACCT_ID AS 'ACCOUNT'
BY OTLT_ADDR_CITY_NM AS 'CITY'
BY VISA_disc AS 'VISA DISC'----------->this thing
BY MC_disc AS 'MC DISC'-------------->this thing

Am i doing in correct way

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


WebFOCUS 7.6
Windows, all output
 
Posts: 5 | Registered: May 18, 2010Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Try this:

DEFINE FILE HOLDFILE1
 MC_disc= IF PRDT_CD EQ '002' THEN FEE_RETL_AM ELSE 0 ;
 VISA_disc= IF PRDT_CD EQ '001' THEN FEE_RETL_AM ELSE 0 ;
END

TABLE FILE HOLDFILE1
 SUM
  TOTTXN AS 'NET TRANSACTIONS'
  TOTVOL AS 'NET SALES'
  CB_TRAN_CT AS 'CHARGEBACK TRANSACTIONS'
  US_CB AS 'CHARGEBACK SALES'
  VISA_disc AS 'VISA DISC'
  MC_disc AS 'MC DISC'
 BY BANK_ROOT AS 'MERCHANT GROUP'
 BY OTLT_CNCY_CD AS 'CURRENCY CODE'
 BY OTLT_ACCT_ID AS 'ACCOUNT'
 BY OTLT_ADDR_CITY_NM AS 'CITY'
 BY FEE_RETL_AM NOPRINT
 .
 .
 .
END


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Waz
Expert
posted Hide Post
quote:
MC_disc= IF PRDT_CD EQ '002' THEN FEE_RETL_AM ELSE 0 ;
VISA_disc= IF PRDT_CD EQ '001' THEN FEE_RETL_AM ELSE 0 ;


Also its good practice to give DEFINE and COMPUTE fields a format, it will show others that may work with your code what the format of the field is.
If the format is omitted, it will default to D12.2


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Darin Lee
Virtuoso
posted Hide Post
It's also a good practice to put a more descriptive title on your post so those who may be able to help know what you're question is about.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders