% Complete Formatting in JOIN Formula

Tiffany Ross
✭✭
I am trying to Join various data points into one cell and when I join the % complete, it changes to decimal format. I've tried adding Value in from of the %complete, but get the same result.
Can someone let me know if there is something I should add to my join formula to convert the decimal to percentage?
Thank you
Tiffany
Answers
-
I just found this community chat that helped me solve the issue.
Thank you @Samuel Mueller
=value@row*100+"% "+unit@row
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives