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?
Discussion posts and replies are publicly visible
Hi goddativ5526
This is how appian renders the value, you can find the exact value in "Expression".
Hi Vyshnavi Naripeddi , I am writing that code expression only
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
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.
Vyshnavi Naripeddi , you can see this in your expression rule by switching the value display from Formatted to Expression