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

rajeshs over 8 years ago

Decimal field value greater than 9999999, Appian converts into Exponential format automatically. When we pass this value to service, service is giving error stating it is expecting as decimal not scientific. Is there any possibility to avoid this automatic conversion to exponential format. Please note that we can not use fixed function because output of this function is Text type and not decimal. Please advise. Is it a service issue? Or can we do something at Appian end to avoid exponential format. Thanks.

Discussion posts and replies are publicly visible

Parents

0 bhanuprakashm over 8 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 bhanuprakashm over 8 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data