Skip to main content

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

  • May 8, 2020
  • 1 reply
  • 201 views
S
Forum|alt.badge.img+5

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

S
Forum|alt.badge.img+5
  • SteelsmithHaus
  • Author
  • Participating Frequently
  • May 8, 2020

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.

ScottWorld
N
Mohamed_Swella1
Terms & ConditionsAccessibility statement