Form Calculation: How to use a comma to separate thousands?

  • JFedGMW
    Asked on February 16, 2017 at 7:47 PM
    How do you add a comma as a separator so that when an amount is in the thousands, it appears as  3,249 and not 3249?
  • Kevin Support Team Lead
    Replied on February 16, 2017 at 7:51 PM

    You could use the commaSeparate() function to achieve it, to use it simply click on the options button in the widget wizard: 

    Form Calculation: How to use a comma to separate thousands?  Image 1 Screenshot 40

    On the math functions tab you need to scroll down until find the function: 

    Form Calculation: How to use a comma to separate thousands?  Image 2 Screenshot 51

    Do note that all the calculations need to be done between the function parenthesis, the result should be like this: 

    Form Calculation: How to use a comma to separate thousands?  Image 3 Screenshot 62

    Hope this helps.