Numerical formatting syntax
Fri, 02/05/2010 - 15:22
Hi,
here a quote of the user guide:
Quote:
The following syntax is used:
%s. Placed value
%d. Decimal (whole numbers)
%.1f. Floating point, 1 decimal
%.2f. Floating point, 2 decimals
%%. Percentage character
Is it possible to create a syntax with two digits after comma, with thousands separator (as a point) like this:
1.234,54
Best regards
Tue, 02/09/2010 - 11:04
#2
There is an existing Feature Request for the thousand separator in Smart Catalog. (BugZero Issue# 131)
Wed, 02/10/2010 - 10:07
#3
This issue had been fixed in the build - V6.0.2 b27. (BugZero issue 271)
The following notations are added to the list of Number Formats for Formula:
€ 1.234
€ 1234,10
€ 1.243,10
1.234
1234,10
1.243,10
1234,1
1.243,1
1,1%
1,10%
Cindy Chen
Wed, 02/10/2010 - 11:06
#4
Hi Cindy,
nice. When and how this build will be available?
Best regards
Wed, 02/10/2010 - 11:54
#5
Unfortunately there is a mix up of products here.
For Smart Catalog there is a feature request, BugZero Issue #131.
BugZero issue #271 has been fixed for Smart Styles v6.0.2.
Dear Stefan,
I have a same request from our customer.
Here is answer from Daniel Lowenstein, cite:
Using a formatting rule it is possible to add "Kč" as a suffix behind fields that hold currencies. But using a xx.xxx format can only be used if the value is stored exactly like that in the database itself (as a Float with 3 digits after the point).
Smart Catalog does not support a thousand point separator (for an Integer with value 12345, it is not possible to transform this to 12.345)
Marek CERMAN
-----------------------
AMOS Software Ltd.
Prague, Czech Republic
mailto:cerman@amsoft.cz
http://www.amsoft.cz/
tel +420 284 011 285
-----------------------