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
[Solved] Easy Fix??
 Login/Join
 
RonT
Member
posted
Prints fine in Excel but not in HTML.

Code:

DEFINE FILE FS_ROOT
DISPVAL/A9=
IF J0.SEG01.FSDISPTP EQ 'D' THEN '(D16.2CM)'
ELSE IF J0.SEG01.FSDISPTP EQ 'P' THEN '(D16.4%)'
ELSE IF J0.SEG01.FSDISPTP EQ 'C' THEN '(D16C)' ELSE 'D16.4';
END
TABLE FILE FS_ROOT
PRINT
FS_ROOT.SEG01.FSCALVALOUT/J0.SEG01.DISPVAL AS 'Cal Value'
FS_ROOT.SEG01.FSMANVALOUT/J0.SEG01.DISPVAL AS 'Man Value'
FS_ROOT.SEG01.FSREPVALOUT/J0.SEG01.DISPVAL AS 'Rep Value'

Excel Result:

Cal Value Man Value Rep Value DISPVAL
17,103 0 17,103 (D16C)
11.9101% .0000% 11.9101% (D16.4%)
$1,486,797.70 $.00 $1,486,797.70 (D16.2CM)

HTML and PDF Result:
Cal Value Man Value Rep Value DISPVAL
+++++++++++++ ++++++++++++ +++++++++++++++ (D16C)
+++++++++++++ ++++++++++++ +++++++++++++++ (D16.4%)
+++++++++++++ ++++++++++++ +++++++++++++++ (D16.2CM)

I'm sure there is a simple fix that I'm not finding.

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


WebFOCUS 8.0.09
ZOS Linux LPAR
All outputs
 
Posts: 12 | Registered: August 11, 2015Report This Post
BabakNYC
Virtuoso
posted Hide Post
Has this ever worked? I thought fieldname/fieldname means divide two fields.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Tom Flynn
Expert
posted Hide Post
Documentation for Dynamically Reformatting a COMPUTEd Field can be found at the top of this thread...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
RonT
Member
posted Hide Post
The dynamic reformatting works in excel but not HTML which is the requested format. I can try the compute to see if it works better.

I used this reference to create it.


WebFOCUS 8.0.09
ZOS Linux LPAR
All outputs
 
Posts: 12 | Registered: August 11, 2015Report This Post
BabakNYC
Virtuoso
posted Hide Post
Very cool technique. I think the problem might be the () around the format in your DEFINE. This example seems to work properly.
DEFINE FILE CAR
FMT/A8=IF COUNTRY EQ 'JAPAN'   THEN 'I9C'    ELSE 
       IF COUNTRY EQ 'ENGLAND' THEN 'D21.2%' ELSE 
       IF COUNTRY EQ 'FRANCE'  THEN 'D20CM'  ELSE 'D21.4';
END
TABLE FILE CAR
PRINT RETAIL_COST/FMT
BY COUNTRY
END


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
RonT
Member
posted Hide Post
That worked. I couldn't find the Forum entry that specified the () but weird that it worked for Excel. Thanks!


WebFOCUS 8.0.09
ZOS Linux LPAR
All outputs
 
Posts: 12 | Registered: August 11, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders