Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Rounding two decimal places (instead of all of them) in a concatenated comma separated formula field

Topic Labels: Formulas
6389 1
cancel
Showing results for 
Search instead for 
Did you mean: 
SteelsmithHaus
6 - Interface Innovator
6 - Interface Innovator

I am concatenating multiple fields into one comma separated field, and even though the formula format is 2 decimals, it’s showing as a whole bunch of them in the concatenated field.

I’ve tried rounding but I can’t seem to get it right. Included pic.
LP_Database_V4_DEV_CostarID_Airtable

1 Reply 1
SteelsmithHaus
6 - Interface Innovator
6 - Interface Innovator

Hey look I actually figured out my own problem:

In the formula fields you are concatenating, you wrap the formula with the round formula like this:

IF({Avg Rent Per 1br}="",0,ROUND(({Avg Rent Per 1br}/{Avg SF Per 1br}),2))

or Round([FORMULA],2) the two is 2 decimals.