Focal Point
amount format for $0.00

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8261034662

January 16, 2008, 01:12 PM
mike
amount format for $0.00
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
January 16, 2008, 01:26 PM
Frans
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.
January 16, 2008, 01:33 PM
mike
that works! thanks!


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats