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

0 rajeshs over 8 years ago

Hi stefanh791, Thanks for your reply!! In my form vehicle.odo is of type text. Even if I change it to decimal type, it's value gets converted to exponential format when value is more than 9999999. See a sample example for your reference. I have declared a variable input of type Decimal when I provide value more than 9999999 then it gets automatically converted to exponential format. I can change it to normal format by applying fixed or text function. But, as the target field (3rd Part Service) is Decimal so while mapping it to it, it again gets converted to exponential format.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 8 years ago

I am having a hard time to explain that. I think the issue is in the chain of form-field-type -> SAIL expression rule input type -> source CDT field type -> target CDT type. As soon as there is a conversion from decimal to text you have to use text() or fixed(). As to my best knowledge there is not a bug in Appian and it works as expected.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel