Skip to main content
shobhits6437
shobhits6437
April 22, 2024
Solved

How can we convert 32354645 to 32,354,645.00 or -922692.31 to -922,692.31

  • April 22, 2024
  • 4 replies
  • 0 views

Hi,

I need help with how can we convert the number 32354645 to 32,354,645.00  or -922692.31 to -922,692.31. 

Can anyone help with logic.

Thanks!

    Best answer by mikes0011

    For this use case, you may also consider "fixed()" --

    4 replies

    mikes0011
    mikes0011
    Brainy
    April 22, 2024

    The text() function is your friend.

    The Expression Guru
      mikes0011
      mikes0011Answer
      Brainy
      April 22, 2024

      For this use case, you may also consider "fixed()" --

      The Expression Guru
        mikes0011
        mikes0011
        Brainy
        April 22, 2024

        Additionally if you expand the "Text Functions" list (in particular) here at the All Functions page, you'll find a lot of neat tools you can use for basic transforms like this and others.

        docs.appian.com/.../Appian_Functions.html

        The Expression Guru
          shubhama926776
          shubhama926776
          Brainy
          April 22, 2024

          Hello [mention:53e48f16520a4945abafe976e4388337:e9ed411860ed4f2ba0265705b8793d05] 

          You can use fixed( number, decimals, no_commas ) function to achieve this.

          शुभम्
            Terms & ConditionsAccessibility statement