
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 31, 2020 08:06 AM
I imagine there is a simple way to do this, but I need to convert a decimal number to a text percentage (0.15 > 15%) to incorporate into a concatenate formula.
2 Replies 2

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 31, 2020 08:10 AM
In the field you are concatenating it in, you should be able to just insert something like this:
... & ({Field with Decimal Percentage} * 100) & "% " & ...
Reply

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 12, 2021 11:24 AM
Sharing another version:
LEFT(ROUND({Field with Decimal Percentage}*100,2) & “%”,7)
Reply
