Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Multiple number formats in same column
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Multiple number formats in same column
 Login/Join
 
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: 72 | Registered: May 21, 2014Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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: 22 | Registered: July 01, 2014Reply With QuoteReport This Post
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: 72 | Registered: May 21, 2014Reply With QuoteReport This Post
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, 2004Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
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: 72 | Registered: May 21, 2014Reply With QuoteReport This Post
Gold member
posted Hide Post
Not sure why my pictures aren't showing up. FRUSTRATING!



WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 72 | Registered: May 21, 2014Reply With QuoteReport This Post
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: 72 | Registered: May 21, 2014Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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: 72 | Registered: May 21, 2014Reply With QuoteReport This Post
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, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Multiple number formats in same column

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.