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     Conversion from Floating-point format( F6.2S ) to intergert or D12.2S to intergert
Go
New
Search
Notify
Tools
Reply
  
Conversion from Floating-point format( F6.2S ) to intergert or D12.2S to intergert
 Login/Join
 
Gold member
posted
Hi
can any one tell me
how to convert from Floating-point format( F6.2S )to integer format
or
Decimal Format to integer format



ex:
614.2-->614
1.00-->1
like this
can any one hlep me Plz


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
Have you considered DEFINE or COMPUTE?


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
considered DEFINE Filed


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi,
Have you tried something as simple as:
DEFINE FILE CAR
ISALES/I9 = SALES ;
END

Bear in mind that this "truncates" the value i.e.
614.2 --> 614
as well as e.g.
614.9 --> 614
If you want it to "round" the value rather than truncate, you'll need to look at using functions like ROUND and FPRINT.


WebFOCUS 8.2.06 mostly Windows Server
 
Posts: 202 | Location: Johannesburg, South Africa | Registered: September 13, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Conversion from Floating-point format( F6.2S ) to intergert or D12.2S to intergert

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