SPS 18 Supress last zero decimal

[Former Member]

Hi veryone,

we upgraded from SPS17 to SPS18 and since this we have the problem that the output is

223,342,342.2 instead of

223,342,342.20.

The format ist numeric local and did not changed.

any ideas ?

thanks

thomas

[Former Member · Accepted solution]

Hi

Try using NSTR function & then give required format.

Regards

Sandeep

[Former Member · Accepted solution]

Sandepp is right.

just to elaborate his answer, you need to use the NSTR function with a ".XXX" parameter

e.g.

NSTR(@FIELD_NAME, ".3") for 3 decimal digits after the seperator

or NSTR(@FIELD_NAME, "C.3") for 3 decimal digits after the seperator, and a comma seperator.

there were indeed bugs fixes in the field of Numeric formatting, so this could suggest why the behavior is different.

[Former Member · Accepted solution]

hi i just talked with the deveoper,

we have the German Format which is coma and . a separator for

223.342.342,2

223.342.342,20.

he tried different combinations witout getting the right german format.

futher ideas ?

[Former Member · Accepted solution]

Yes.

if you wish to use both Locale (German) and formatting - i.e. with thosand seperator (which is in this case a "." and 4 digits after the decimal seperator (which is "," in this case)

you will use

NSTR(@NumberField, "C.3L")

C = thosand seperated

.3 = 3 digits after the decimal seperator

and most importantly

L = LOCALED

[Former Member · Accepted solution]

Hi

Just check what 'data type' your developer is using. I think he is taking data type as 'T - Text'. Just consider the 'Number Type' & then i think you will get the required result.

Regards

Sandeep

[Former Member · Accepted solution]

Hi,

thanks to all. Since our developer must change hundreds of fields we try to implement SPS19.There are several

bugfixes with the local number format of non ENUS locales. SAP Note 1288258

thanks for your help

regards

Thomas