Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
7 subscribers
Views
3410 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
We are taking user input for Currency ($) on our forms. However, we have used no
nikhilh0001
over 11 years ago
We are taking user input for Currency ($) on our forms. However, we have used normal Number type field. The requirement is to show the values in comma format. for eg 10000 should be displayed as 10,000. We have calculations based on this input, so it has to be number field. How can we achieve this? Thanks in advance...
OriginalPostID-71509
OriginalPostID-71509
Discussion posts and replies are publicly visible
0
akhilan
over 11 years ago
Take a look at the currency() and dollar() functions to see if they fit your requirement. Here is the reference link -
forum.appian.com/.../Text_Functions
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ryanh
over 11 years ago
A few months ago I had a similar issue and the users wanted a $ symbol in the field too if possible. I was storing the value as a number(decimal) if I remember correctly. I had problems using the dollar() function because it didn't cleanly handle null values, so be sure to test for this (on Appian 6.6.0). Here are some notes I found:
I had to change the field type from a decimal to a text one to have the $ be visible, but outside of that, I have the default value being:
=dollar(if (isnull(pv!dec_dol_ArgCollateral.purchaseAmount_Dec)<>true,pv!dec_dol_ArgCollateral.purchaseAmount_Dec, 0), 2)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
nikhilh0001
over 11 years ago
Thank you both!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
dennisn
over 11 years ago
Are you able to show the currency value with commas correctly on the Tempo form immediately after user entry? (assuming tempo can't handle javascript)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
nikhilh0001
over 11 years ago
hi dennis, we didnt try yet, we are still on 661 and not using Tempo to a great extent yet.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ashleyb
over 9 years ago
Has there been any new functions to handle this yet? Where the user is able to enter an integer and the field will display it as currency without having to convert it to text?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel