Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Concatenate Formula Fields with 2 decimal digits

Topic Labels: Formulas
Solved
Jump to Solution
2289 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

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

 

Click on the formatting tab to see your formatting options.

Yeah.. I checked already, it is not available

Yerko_Begic_0-1711670003108.png

 

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