How do I get values like 10.2 and 10.203443 to display as 10.20. I am currently

damieng over 10 years ago

How do I get values like 10.2 and 10.203443 to display as 10.20. I am currently using the fixed and round functions and this is working on any values that have more than 2 decimals but how do I fix this for 10.2 to be 10.20?...

Discussion posts and replies are publicly visible

0 Steven Miccile
Appian Employee
over 10 years ago

The text function should work for this use case: text(10.2,"00.00")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jason Ruvinsky
Certified Senior Developer
over 10 years ago

You can try one of the currency functions, if you are displaying a currency. Or you can use text() forum.appian.com/.../Text_Functions to have complete control over how the value is formatted.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 damieng over 10 years ago

Thanks both. Is there no way around this without returning text?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shawn Bittinger
Appian Employee
over 10 years ago

It sounds like the the combination of fixed() and round() might satisfy your use case. forum.appian.com/.../Mathematical_Functions
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel