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     [CLOSED] getting a % symbol in Excel
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] getting a % symbol in Excel
 Login/Join
 
Gold member
posted
Hi All,

I could not able to bring a '%' for a computed column values if I try to bring it in a excel format.. I don't remember the code but I will put a little here just for your idea.

  

TABLE FILE CAR

PRINT CAR
COMPUTE TEST/D12.2% = 10 * DEALER_COST;
ON TABLE PCHOLD AS EXL2K
END



In HTML, I can see the '%' coming for all values in a column (TEST) where as in EXCEL it is not.

I don't want to convert from packed decimal to alpha and concate % symbol

Any idea ?

Thanks!

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


WebFOCUS 7.6.10
Windows
Output: Excel,PDF
 
Posts: 78 | Registered: January 07, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi

This seems to work fine:

TABLE FILE CAR

PRINT CAR
COMPUTE TEST/D12.2% = 10 * DEALER_COST;
ON TABLE PCHOLD FORMAT EXL2K
END
 
Posts: 103 | Registered: March 18, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
What I have found is that the '%' sign is carried into excel for the report data but not subfoots. My fields were packed so I converted them to alpha using the PTOA() function and it pulled the '%' sign in, but they are now alpha values in the excel spreadsheet.


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
 
Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
All data in headings, footings, subheadings and subfootings is in alpha string format. Just append a "%" to the result of the PTOA function.


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
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] getting a % symbol in Excel

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