Focal Point
Numbering Format

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

July 09, 2007, 04:41 PM
<Umar Farook S>
Numbering Format
hi
i need to display a numeric field with comma seperated after every three digits and also woth 2 decimal points

can u please help
July 09, 2007, 04:42 PM
Francis Mariani
TABLE FILE CAR
SUM
SALES/D10.2
BY COUNTRY
END


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
July 09, 2007, 05:07 PM
KK
TABLE FILE CAR
SUM
SALES/D12.2C
BY COUNTRY
END


Test - Webfocus 7.6.7
Prod - Webfocus 7.6.7
Win2003
Sql Server 2000 and 2008
July 10, 2007, 04:02 AM
<JG>
The C is not required for D fields as it is implicit with the format.

D10.2 = 7,654,321.12
D10.2C = 7,654,321.12
D10.2c = 7654321.12