Solved: Truncate Concatenated Value to No More than Two De... - Page 2

mykrobinson · 08-03-2022 10:21 AM

I have an expression to calculate distance and convert to miles loaded in a virtual column. It takes the LATLONG of our office and the LATLONG of the address of whatever clinic is selected (done currently using an AwesomeSheet addon ☹️ ) and sticks it in a virtual column. The expression is currently:

CONCATENATE(((DISTANCE([TKE Jackson],LATLONG([Latitude],[Longitude])))*0.621371),"mi")

How do I go about converting this so that it never displays more than two places past the decimal?

I initially thought about using LEFT() but that would yield slightly unpredictable results.

SkrOYC

At first glance, seems like TEXT() should be enough:

CONCATENATE(
  TEXT(
    DISTANCE(
      [TKE Jackson],
      LATLONG(
        [Latitude],
        [Longitude]
      )
    )*0.621371
  ),
  "mi"
)

View solution in original post

Truncate Concatenated Value to No More than Two Decimal Places