
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 03:35 PM
How do I concatenate these two fields so they show values with not so many digits. I would like to show 2 decimal digits.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 06:27 PM
Try this:
"$" &
ROUND({Daily Fees $}, 2) &
" / " &
ROUND({Daily Fees %} * 100, 2) &
"%"
Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 04:22 PM
Use the ROUND() function surrounding your formula like this:
ROUND(insert the text of your formula here, 2)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 04:38 PM
Close, but not close enough 😉. The % is not correct and I would also like to show $ sign as well as % sign. Is that possible?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 04:50 PM
Click on the formatting tab to see your formatting options.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 04:53 PM
Yeah.. I checked already, it is not available

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 04:59 PM
That’s because your result is not a number… it’s text. You would have to add in those symbols yourself as part of your formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 05:16 PM
I have added symbols, but looks like $ sign can only go in the back which is incorrect. Not sure if there is a way to put it in the front (I have tried to fiddle around and couldn't figure it out). Also, still have the same issue with % not showing correctly with the ROUND formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 05:28 PM - edited ‎Mar 28, 2024 05:28 PM
Put the $ sign at the very beginning of your formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 05:55 PM
I have tried, but it is not taking the formula
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2024 06:27 PM
Try this:
"$" &
ROUND({Daily Fees $}, 2) &
" / " &
ROUND({Daily Fees %} * 100, 2) &
"%"
Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!
