toxml() is updating Double/Decimal values

jayashrib223 over 7 years ago

Hi,

We have a CDT (testCDT) with one attribute of type Number(Decimal).
When we have attribute value as 0.00055, toxml(testCDT) returns value as '5.5E-4'

Does anyone know how to avoid this.

Thanks,
Jayashri

Discussion posts and replies are publicly visible

0 kacie.bail
Appian Employee
over 7 years ago

Hi! I think if you use toxml(fixed(testCDT,5)) it should solve your issue. If you need this to be more dynamic to account for varying numbers after the decimal, I think you might be able to create a separate rule to do this.

Here's some more information too about the fixed function: forum.appian.com/.../Text_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

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

When I check the XML documentation, scientific notation is valid. See www.safaribooksonline.com/.../ch04s04.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jayashrib223 over 7 years ago

Thanks Kacie and Stefanh! Stefanh, based on this document for Double it's valid but we have data type Decimal.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel