Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Concatenate Formula Fields with 2 decimal digits

Topic Labels: Formulas
Solved
Jump to Solution
3425 11
cancel
Showing results for 
Search instead for 
Did you mean: 
Yerko_Begic
6 - Interface Innovator
6 - Interface Innovator

How do I concatenate these two fields so they show values with not so many digits. I would like to show 2 decimal digits.

Yerko_Begic_0-1711665242079.png

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try this:

"$" & 
ROUND({Daily Fees $}, 2) & 
" / " & 
ROUND({Daily Fees %} * 100, 2) & 
"%" 

Screenshot 2024-03-29 at 9.25.55 AM.png

Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!

Link to base

See Solution in Thread

11 Replies 11
ScottWorld
18 - Pluto
18 - Pluto

Use the ROUND() function surrounding your formula like this:

ROUND(insert the text of your formula here, 2)

Close, but not close enough ðŸ˜‰. The % is not correct and I would also like to show $ sign as well as % sign. Is that possible?

Yerko_Begic_0-1711668966244.png

 

ScottWorld
18 - Pluto
18 - Pluto

Click on the formatting tab to see your formatting options.

Yeah.. I checked already, it is not available

Yerko_Begic_0-1711670003108.png

 

ScottWorld
18 - Pluto
18 - Pluto

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. 

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 

Yerko_Begic_0-1711671389977.png

 

 

ScottWorld
18 - Pluto
18 - Pluto

Put the $ sign at the very beginning of your formula. 

I have tried, but it is not taking the formula

TheTimeSavingCo
18 - Pluto
18 - Pluto

Try this:

"$" & 
ROUND({Daily Fees $}, 2) & 
" / " & 
ROUND({Daily Fees %} * 100, 2) & 
"%" 

Screenshot 2024-03-29 at 9.25.55 AM.png

Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!

Link to base