How do I format the calculation as currency

mleppin

Asked on January 10, 2017 at 8:56 AM

https://form.jotform.com/70054598538970

How do I format the calculation as currency
candy

Replied 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.
mleppin

Replied 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

...
BJoanna

Replied on January 10, 2017 at 1: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.