Help

Number Separator in formula field with a text

Topic Labels: Formulas
Solved
Jump to Solution
498 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jot
4 - Data Explorer
4 - Data Explorer

Hi. 

Thank you in advance, I am wondering if there is a way to show numbers with thousand/comma separator if you combine it with a text in a formula field using concatenate. My Amount field is in currency format. 

Current Formula: 

CONCATENATE(Amount, " ", {asking-currency})

Much appreciated.  

jot_0-1697117107873.png

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @jot ,

I've developed an inexplicable formula.

 

REGEX_REPLACE(
  REGEX_REPLACE(
    REGEX_REPLACE(
      REGEX_REPLACE(
        REGEX_REPLACE(
          REGEX_REPLACE(ROUND({Amount})&"", "(\\d{3})$", ",$1"),
          "(\\d*)(\\d{3}),",
          "$1,$2,"
        ),
        "(\\d{1,3})(\\d{3}),",
        ",$1,$2,"
      ),
      "(\\d{1,3}),(\\d{3}),",
      "$1,$2,"
    ),
    "^(\\d{1,3})(\\d{3}),",
    "$1,$2,"
  ),
  "^,",
  ""
) & " " & {asking-currency}

 

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @jot ,

I've developed an inexplicable formula.

 

REGEX_REPLACE(
  REGEX_REPLACE(
    REGEX_REPLACE(
      REGEX_REPLACE(
        REGEX_REPLACE(
          REGEX_REPLACE(ROUND({Amount})&"", "(\\d{3})$", ",$1"),
          "(\\d*)(\\d{3}),",
          "$1,$2,"
        ),
        "(\\d{1,3})(\\d{3}),",
        ",$1,$2,"
      ),
      "(\\d{1,3}),(\\d{3}),",
      "$1,$2,"
    ),
    "^(\\d{1,3})(\\d{3}),",
    "$1,$2,"
  ),
  "^,",
  ""
) & " " & {asking-currency}

 

 

Thank you very much!