How do I format the calculation as currency

  • Profile Image
    mleppin
    Asked on January 10, 2017 at 08:56 AM
  • Profile Image
    candy
    Answered on January 10, 2017 at 10:10 AM

    Hello,

    As I have checked, your question is already answered in the following thread link: https://www.jotform.com/answers/1027754-How-do-format-form-calculator-results-to-currency 

    Please check it.

    Thank you.

  • Profile Image
    mleppin
    Answered on January 10, 2017 at 11:45 AM
    Yes The $ sign is visible but the calculation result is formatted like this: $1025886,00 trying to get it to look like $1,025,886.00. Once we report in a spreadsheet. The , will not roll up on the totals.

    Melissa Le’ppin | EVP | CGMP
    Ph: 1-800-898-1347 x230 | Fx: 1-888-559-8160 |
    HotelPlanner.com | Meetings.com | melissa.leppin@hotelplanner.com
    cid:image001.png@01D12DD4.173F8310 meetings http://cdn.hotelplanner.com/Common/Images/fastest-growing66.png
    GSA Contract: GS-33F-014CA } U.S. Communities Contract: EV2048

    Connect with me on Linkedin and learn about our Bringing People Together partnership with Dylan Ratigan

    ...
  • Profile Image
    BJoanna
    Answered on January 10, 2017 at 01:28 PM

    If I understood you correctly you want to separate thousands with a comma. To achieve this you will need to add commaSeparate option inside of your form calculation widgets. 

    You will also need to uncheck option for your second field to use comma as decimal point.

     

    Here is my demo form: https://form.jotform.com/70094842349966 

    Feel free to test it and clone it.

    Hope this will help. Let us know if you need further assistance.