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
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