How do I format the result of a calculation like money, with the currency symbol before it and two decimal places at the end?

  • Profile Image
    venco_80
    Asked on January 19, 2015 at 03:12 PM
  • Profile Image
    abajan
    Answered on January 19, 2015 at 03:56 PM

    Thanks for asking. You would insert the currency symbol before the formula and then click Show Advanced Options. Please see the screenshot below:

    The solution was used in this jotform.

    If you need further explanation, we'd be happy to provide it.


    Cheers

  • Profile Image
    venco_80
    Answered on January 19, 2015 at 04:14 PM

    Yes that is right, but not hapend to me. Dont know why?

  • Profile Image
    raul
    Answered on January 19, 2015 at 04:26 PM

    Could you please let us know which form have the calculation widget included? I've checked all your forms but, unfortunately, was unable to find the widget in any of them.

    You may also clone the demo form provided by @abajan in case you want to test it further.

    Let us know if you need further assistance.
    Thank you.

  • Profile Image
    venco_80
    Answered on January 19, 2015 at 04:43 PM

    http://www.jotform.com//?formID=50174809710352, BUT NEED TO CHOOSE TYPE OF PRODUCT FIRST AND THEN IS COME OUT. I dont know how made it

  • Profile Image
    raul
    Answered on January 19, 2015 at 05:23 PM

    Thank you for providing more information.

    I've made a cloned version of your form to make some tests, you can find it here: http://form.jotformpro.com/form/50186947966977

    I'm assuming that the values in the calculation widget should be taken depending on the selected option(s) in the checkboxes. If this is correct then you need to populate the Calculation Values field which you can see by right-clicking each checkbox field and selecting Properties.

    Each numeric value corresponds to the selected option. For example, in the image below Option 1 would have a price of 10, Option 2 would have a price of 15 and Option 3 would have a price of 20

    Once this is done then you need to create the operation that should be performed in the calculation widget. For example, adding the prices for all selected checkboxes like in the picture below.

    And that's it. You can also clone the demo form to your account if you want to.

    Let us know if this helps.
    Thank you.

  • Profile Image
    venco_80
    Answered on January 20, 2015 at 07:55 AM

    Thanks, I fix it as I want it.

  • Profile Image
    Ben
    Answered on January 20, 2015 at 09:35 AM

    In my colleagues' names you are welcome. It is great to hear that you got it working now.

    Do let us know if you have any further questions and we would be happy to assist.