topic Re: smartform number formatting in Application Development and Automation Discussions

smartform number formatting

karthick1608 — Wed, 23 Jan 2019 11:04:50 GMT

Hi,

In the smart form output,

previously the value maintained was 5348.16.

it should be converted to -5348.16 instead of -534.816.

-534.816 is due to the logic maintained in smart form was 'fieldname(<C.0)'.

Why it is printed as such? what is the logic of above formatting ?

How can I overcome this ?

Thanks

Karthick

RaymondGiuseppi — Wed, 23 Jan 2019 12:46:48 GMT

(First read Rules of Engagement and remove the 'as soon as possible'.)

Then search/read online help or forum, e.g. Output Options for Field Contents (so you will understand that So '<' is sign left, 'C' is condense and '.0' is no decimal) and then consider reading Fields that Refer to Currencies or Quantities too.

karthick1608 — Fri, 25 Jan 2019 11:24:19 GMT

but in my variable it is displaying with 2 decimal point.

Like 5.612.312

it must be like 5,612,312.00

how can i modify the change?

Former Member — Fri, 25 Jan 2019 13:06:08 GMT

Is this a currency value ? Have you maintained the currency format in the form ?

Florian — Sat, 26 Jan 2019 14:22:52 GMT

but in my variable it is displaying with 2 decimal point.
Like 5.612.312 
it must be like 5,612,312.00
how can i modify the change?

This comes from the country-specific settings. HAve a look in table T005 and also at

SU3 / SU01 & Global Settings OY01

The samrtforms gives you this result because of a setting here.

Sandra_Rossi — Sat, 26 Jan 2019 15:13:15 GMT

@Karthick R : Raymond told you that .0 means no decimal. If you search a little bit, you can imagine that .2 means 2 decimals... Examples here: https://help.sap.com/saphelp_nw70/helpdata/en/d1/803479454211d189710000e8322d00/content.htm

karthick1608 — Mon, 28 Jan 2019 04:56:38 GMT

Yes, it is a currency value. It is maintained correctly.