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     amount format for $0.00
Go
New
Search
Notify
Tools
Reply
  
amount format for $0.00
 Login/Join
 
Platinum Member
posted
how can I print an amount of $0.00 (floating dollar with ONE zero). D12.2CLM prints a fixed dollar like this $000,000,000.00 and D14.2C!D prints floating dollar with no zero like this $.00


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
 
Posts: 102 | Registered: April 20, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
Try

SET CENT-ZERO = ON


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 453 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
that works! thanks!


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
 
Posts: 102 | Registered: April 20, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     amount format for $0.00

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