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