Text To Number conversion

Forum|Forum|1 year ago
April 15, 2025
5 replies
4 views

Hi team, I have one field in the database for the budget. Sometimes the value may exceed 100 crores, so for storage purposes, I am storing it as text. However, I want to compare that value with an integer. When I tried to convert it into number in Appian, it rounds the value by default. Any idea how we can achieve exact value?

V

vyshnavin653512

Participating Frequently

Hi [mention:b47709aa823c422e99c324cbdda67103:e9ed411860ed4f2ba0265705b8793d05]

This is how appian renders the value, you can find the exact value in "Expression".

G

goddativ5526Author

Known Participant

Hi [mention:1c6f36915a6c4d3a8444dd997b2ebc07:e9ed411860ed4f2ba0265705b8793d05] , I am writing that code expression only

V

vyshnavin653512

Participating Frequently

Expression in the "Test Output"

If you want the exact value after converting to decimal, you can use fixed function but it will give the output as text

stefanhelzle0001

Brainy

Appian does not round your number, but displays it as rounded. This is just the normal way an internal value is turned into text for display purposes.

Z

zakarym8213

Inspiring

[mention:1c6f36915a6c4d3a8444dd997b2ebc07:e9ed411860ed4f2ba0265705b8793d05] , you can see this in your expression rule by switching the value display from Formatted to Expression

Sign up

Login with SSO

Login to the community

Login with SSO