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

Discussion posts and replies are publicly visible

Parents

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

Reply

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

Children

No Data