
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 08, 2020 03:49 PM
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.
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 08, 2020 04:13 PM
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.
Reply
