Decimal field value greater than 9999999, Appian converts into Exponential forma

This is just a matter of display. When calling the service you can use the text() function to format the number. Try this: =text(99999999.0, "### ### ###.##")

BTW, searching for "exponential" gives you many discussions and solutions to your problem.

Hi Rajeshs,
Use this code for decimal val displaying more than 9999999
fixed(ri!decimalval,0,true) ..Its helpful to you.

in place of "0" you can place any integer value for number of digits after the decimal that will be maintained

Hi, Thanks for the reply. But, my issue is target service schema is of Decimal type. Even if we use fixed function, it's return type is text and while mapping to target field, it will again converted to exponential format. I don't need it for display purpose.

So you are calling a web service ? What is the data type of the field? What method do you use to call it? Smart Service or expression? Please elaborate and add screen shots and/or code snippets.

Try passing the string value as is text() function output... As far as there are no alphabets, the service would take the value.. Else, make it a text field and handle the conversion at the service level which is called.. We have done similar to a date field, making it a string parameter as the date gets converted to GMT when we receive it in Appian..

Hi Rajeshs,
As per my knowledge,if you are using decimal field for displaying values it displayed up to 9999999(7 integer values) values only more than that it will converts exponential symbols. Better to change the data type either integer (it displays up to 9 integer values or text(13 integer values) or provide the validation for users suppose if they are enter more than 7 values

Hi . We are using script Task where we are doing source to Target CDT mapping. Target PV is of Service CDT type and Source PV is of Appian CDT. I am attaching the screen shot for your reference.

ScreenShot.docx

Thanks for the info. Just to make one thing clear. The internal representation of a decimal in Appian always is the Java type double precision floating point. What you see is the conversion to a text representation which is different for smaller and larger numbers.

I try to explain what I see in my analysis.

In your screenshots the source field is of type text multiple. So when you have a decimal field in your form and save that to this text field, the value will already be converted to text and exponential form. Mapping this to a decimal field will not work for bigger numbers. See this test

=text(todecimal(tostring(9999999999.0)), "#.#")

So my suggestion is to change vehicle.odo to decimal type or use the text() function in the saveInto of the form field to make sure the textual representation of the decimal number is correct.

=text(todecimal(text(9999999999.0, "#")), "#")