How to format numbers with dollar signs and decimals

  • Profile Image
    Asked on August 22, 2017 at 05:46 PM


    Can you please guide me as to how to format the output values to contain dollar signs ($), commas (,) and decimal points (.) when necessary on my form?

    Thank you in advance for your great support!


  • Profile Image
    Answered on August 22, 2017 at 07:28 PM

    It is possible to use the a comma to separate large quantities, you only need to add the "commaseparate" function to your form, please find more about this and other functions on the following link: 

    To set the number of decimal places and the symbol to be used for decimals, you could do this under the widget options: 

    Now, regarding the dollar sign, you will need to manually add it to your calculation as there is not a function to format the result as money. The dollar sign can be added using your keyboard, just like if you were adding text. 

    You could also add a widget to your form in order to format the numbers, please check this guide that will provide you with more details about it: 

    I hope this helps.