Concatenate Formula Fields with 2 decimal digits

[Yerko_Begic]

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

[ScottWorld]

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

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

[Yerko_Begic]

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

[ScottWorld]

Click on the formatting tab to see your formatting options.

[Yerko_Begic]

Yeah.. I checked already, it is not available

[ScottWorld]

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. 

[Yerko_Begic]

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 

[ScottWorld]

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

[Yerko_Begic]

I have tried, but it is not taking the formula

[TheTimeSavingCo · Accepted solution]

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!

Link to base