Skip to main content
Known Participant
Apr 15, 2025 9:52 AM UTC
Question

Text To Number conversion

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?

5 replies

Participating Frequently
Apr 15, 2025 10:11 AM UTC

Hi [mention:b47709aa823c422e99c324cbdda67103:e9ed411860ed4f2ba0265705b8793d05] 

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

Known Participant
Apr 15, 2025 10:13 AM UTC

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

Participating Frequently
Apr 15, 2025 10:14 AM UTC

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
Apr 15, 2025 10:35 AM UTC

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.

Inspiring
Apr 15, 2025 2:42 PM UTC

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