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 firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
We have a requirement to display both Integer value and Decimal value in one column.
To simplify, for example, how can we display 1 row (suppose has only 1 column) with the integer value 10 (the count of quantity), and the second row showing the decimal value 98.99 (the total sales amount $).
Is there a way to do that in one TABLE command (request)?
WilliamThis message has been edited. Last edited by: <Kathryn Henning>,
Jack Gross is correct. FML (Financial Modeling Language, AKA EMR and FRL) allows you to use the FOR and OVER commands to mix and match formats. I have done this, but I do not have an example readily available. I'll search my archives.
Could not fin in my archive so I put this together. Master File ---------------------- FILENAME=TESTFML, SUFFIX=FOC, SEGNAME=BUDGET, SEGTYPE=S1, $ FIELDNAME=CODE, ALIAS=CODE, USAGE=A12, ACTUAL=A12, $ FIELDNAME=BUDGET, ALIAS=BUDGET, USAGE=D8.2, ACTUAL=D8, $ Data ----------------------------- POLES.......25.00 A_CABLE....125.80 MANHOLES.....5.00 U_CABLE....502.80 FEX ------------------------------ TABLE FILE TESTFML SUM BUDGET FOR CODE POLES LABEL DPOLE NOPRINT OVER RECAP IPOLE/I5 = DPOLE ; AS 'POLES' OVER A_CABLE OVER MANHOLES LABEL DMANHOLE NOPRINT OVER RECAP IMANHOLE/I5 = DMANHOLE ; AS 'MANHOLES' OVER U_CABLE END Results -------------------------- POLES...........25 A_CABLE.....125.80 MANHOLES.........5 U_CABLE.....502.80
In the reports, the numerical values are aligned properly. This posting removes excess spaces, so I inserted dot leaders to help reading.This message has been edited. Last edited by: John W Price,
WebFOCUS 8.0.2, FOCUS since 1977 - John@Aviter.com PDF , Excel, FOCUS, Author of the Keysheets and Dates book. www.Aviter.com
Why can't you set the format or "products sold" to "I11" and you "sales $" to "D12.2". You can do tha in the Master or in the FEX in a DEFINE or a COMPUTE or directly by adding "/[format]"after the field declaration.
WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003
What do you mean by "similar solution for rows" ? What are you trying to perform ?
In a sense, each data displayed on a row is part of a column.
Tell me if I'm right and if I understand properly your question ?
Let say we have a report with 2 rows and 3 columns. What you want is per example:
row-1 for all 3 columns display alpha data row-2 for all 3 columns display number in numeric format
I think that the answer maybe in MacGyver technique. Lot of post and info in technical library.
Otherwise you will have to perform one HOLD file per row types where you will use the FPRINT for every column of that row type and have each corresponding column of each row with the same output format (alpha same length). Finally merge all the HOLD files.
TABLE FILE CAR
PRINT COMPUTE COL1 /A20 = FPRINT(CAR, 'A16', 'A20');
COMPUTE COL2 /A40 = FPRINT(MODEL, 'A24', 'A40');
ON TABLE HOLD AS TMP1 FORMAT FOCUS
TABLE FILE CAR
SUM COMPUTE COL1 /A20 = FPRINT(SEATS, 'I3', 'A20');
COMPUTE COL2 /A40 = FPRINT(SALES, 'I6', 'A40');
ON TABLE HOLD AS TMP2 FORMAT FOCUS
TABLE FILE TMP1
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2410 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013