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] Multiple number formats in same column

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Multiple number formats in same column
 Login/Join
 
Deej
Gold member
posted
I need to format numbers differently in the same column. I'd like the numbers at the top of the report to be integer and the numbers at the bottom, in grey, to be % with one decimal.

Is there any way to format them differently?

We're using version 7703.

Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,



WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 67 | Registered: May 21, 2014Report This Post
Francis Mariani
Expert
posted Hide Post
Look for "Applying Dynamically Formatted Virtual Fields to Report Columns" in the documentation, described in the GUI section of the docs, or here:

Creating Reports With WebFOCUS Language > Creating Temporary Fields > Defining a Virtual Field > Applying Dynamically Formatted Virtual Fields to Report Columns


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
HarryLo
Member
posted Hide Post
Hi Deej, You can do it in at least one of two ways. Use a Subfoot or use FML with Recaps. There may be other ways also.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 24 | Registered: July 01, 2014Report This Post
Deej
Gold member
posted Hide Post
Thanks for the suggestions, I'll take a look.

Sorry for the late reply, my computer went down shortly after I posted this and I'm just now getting back up and running.

Thanks,

DJ



WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 67 | Registered: May 21, 2014Report This Post
jimbo
Silver Member
posted Hide Post
 
DEFINE FILE CAR
NEWFMT/A8              = IF COUNTRY EQ 'ENGLAND' THEN 'D15M'  ELSE 'D15.2'  ;
END
TABLE FILE CAR
LIST COUNTRY DEALER_COST/NEWFMT 
END


7.7.04
Win2K3, Unix
Oracle 10G,SQL2K,XFOCUS,ESRI,BID,MRE,SELF-SERVICCE
 
Posts: 36 | Location: Melville,NY | Registered: August 09, 2004Report This Post
susannah
Expert
posted Hide Post
what jimbo says.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Deej
Gold member
posted Hide Post
jimbo, I tried applying your suggestion to my report and I'm almost there, just need a tweak but I'm not sure how to tweak it.

My original report code shows this:

-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;
TABLE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL

SUM
METRIC NOPRINT
ACTUAL/P6.1BCS AS 'Actual'

BY METRIC_SEQUENCE NOPRINT
BY METRIC AS ''
ACROSS HIGHEST YEARMONTH AS ''



And when I tried to apply your code to my report:

DEFINE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL
ACTUAL/A8 = IF METRIC EQ '% Opened New Construction' THEN 'P2.1BCS%' ELSE IF METRIC EQ '% Opened Retail' THEN 'P2.1BCS%' ELSE IF METRIC EQ '% Opened Commercial' THEN 'P2.1BCS%' ELSE IF METRIC EQ '% Opened Other' THEN 'P2.1BCS%' ELSE 'P6C' ;
END

-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;
TABLE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL

SUM
METRIC NOPRINT
ACTUAL

BY METRIC_SEQUENCE NOPRINT
BY METRIC AS ''
ACROSS HIGHEST YEARMONTH AS ''




I know I'm close, but what do I need to change/add?



WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 67 | Registered: May 21, 2014Report This Post
Deej
Gold member
posted Hide Post
Not sure why my pictures aren't showing up. FRUSTRATING!



WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 67 | Registered: May 21, 2014Report This Post
Deej
Gold member
posted Hide Post
Got it!!

DEFINE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL
NEWFMT/A8 = IF METRIC EQ '% Opened New Construction' THEN 'P6.1BCS%' ELSE IF METRIC EQ '% Opened Retail' THEN 'P6.1BCS%' ELSE IF METRIC EQ '% Opened Commercial' THEN 'P6.1BCS%' ELSE IF METRIC EQ '% Opened Other' THEN 'P6.1BCS%' ELSE 'P6C' ;
END

-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;
TABLE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL
SUM

METRIC NOPRINT


ACTUAL/NEWFMT AS 'Actual'

BY METRIC_SEQUENCE NOPRINT
BY METRIC AS ''
ACROSS HIGHEST YEARMONTH AS ''



WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 67 | Registered: May 21, 2014Report This Post
Francis Mariani
Expert
posted Hide Post
Quite often tinypic is blocked by the server. In my company it's blocked as a "Adult/Mature Content;Intimate Apparel/Swimsuit" site.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Deej
Gold member
posted Hide Post
So I take it they are showing up in my post for everyone else?

Thanks again for all of the responses.



WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 67 | Registered: May 21, 2014Report This Post
George Patton
Master
posted Hide Post
Nope - no pictures here - and I allow ALL content.


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 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] Multiple number formats in same column

Copyright © 1996-2020 Information Builders