Dollar functions returns $N/A for the value having more than 10 digits

Question

Hi All, 
 
 i have a dollar function inside the value feature of TextField, this works fine if the Value is less than 10 digits, if it is more than 10 , the Dollar functions returns $N/A 
 how can i overcome this 
 Thanks in advance

Peter Lewis · Answer

What is the type for the variable where you store the value entered in the text field? Integers in Appian are limited to 2,147,483,647, so if you enter a value higher than that number, it will display $N/A in your text field. However, if your variable is defined using a decimal or text, it should display correctly with the dollar function.

Bibhuti · Answer

Hello, 
 With text also if the number of characters are exceeding 12 /13 then it wont work properly. 
 
 You can use as below. Here the dollar function is for just adding the symbol before the text and the whole number we ca take as text (but not inside dollar function)- 
 
 a!textField( value:dollar()&"9999999999999999999999999999999999" )

Mike Schmitt · Answer

I don't personally recommend using the code "fn!dollar() & index( etc..." , as this won't actually call the dollar function on the value you're trying to convert (it will just insert a dollar sign, which can be done more easily just typing "$"). 
 To recap, the correct syntax for dollar() is: 
 dollar( (value), (number of decimals) [optional], (exclude commas) [optional] ) 
 This example code (14 9 's, or 99 trillion) works fine - once you add more 9's, the number starts behaing weirdly no matter what you do. 
 dollar(
 "99999999999999",
 2
)

Dollar functions returns $N/A for the value having more than 10 digits

Top Replies