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
8 replies
Subscribers
8 subscribers
Views
3835 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
To display "$" sign before decimal number in record list view
brindas1
over 7 years ago
Hi all,
Is there a way to display $ symbol before decimal numbers in record list view? The list style is grid. I tried dollar function, but it is not working.
OriginalPostID-267438
Discussion posts and replies are publicly visible
0
PhilB
A Score Level 1
over 7 years ago
The dollar function should work. Where exactly are you attempting to implement this - in the record title or the record list? Are you able to post the expression you're using?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brindas1
over 7 years ago
Hi Philb,
I am trying to display the $ symbol in record list grid view. I am using the expression as given below:
dollar(rf!MONTHLY_INCOME,2)
But it doesn't work
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs7821
over 7 years ago
@brindas as per my understanding if you want to display dollar symbol before decimal numbers in record list view, While adding new column in record list view make sure you select component as Text and not Decimal and use dollar function in display value property and pass your decimal record field to dollar function. Please correct me if i'm wrong.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brindas1
over 7 years ago
Mayuresh,
But the data type of the Monthly Income is decimal. How can I select component as Text?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brindas1
over 7 years ago
Mayuresh,
Thanks. Though I can't select it from the dropdown when I change the select component as Text, I can able to use the dollar function inside the expression editor and use the expression dollar(rf!MONTHLY_INCOME). It's working fine now
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs7821
over 7 years ago
@brindas Even if the data type of monthly income is decimal you can select the component as text.As dollar function returns text so you have to select the component as Text. If you select the component as decimal it will not work as expected. PFA screenshot of record List view there total experience is decimal field as i have used text component it is working as expected.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 7 years ago
@mayureshs782 is right - whilst the value may be a decimal, for the dollar sign to display you have to use a text component, as the decimal/floating point component will strip off the added dollar sign.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brindas1
over 7 years ago
Yes. I selected the component as Text and it is working fine. Thanks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel