Order Total not displaying 2 decimal place for a currency value

  • Profile Image
    communications_gsrv
    Asked on April 10, 2019 at 04:06 PM
    There also is an issue with the Order Total not displaying 2 decimal place for a currency value. The Order Total is being passed in by the subtotal calculation field. And thoughts on how to fix this would be greatly appreciated?
  • Profile Image
    Alan_D
    Answered on April 10, 2019 at 04:12 PM

    You can add the decimal place for currency in the condition. You must add one dot as a string and two zeros as a number. 15549268341.png15549268432.png

  • Profile Image
    communications_gsrv
    Answered on April 12, 2019 at 01:52 PM

    Thanks Alan,  unfortunately this doesn't seem to be fixing our issue. When I add the decimal as a string and the two zeros as numbers the calculation breaks and the Order Total field wont update at all. Will this only work if the calculation is addition and not multiplication?

    The Adventure Care Package, Voyager Care Package and Both Care Packages options are calculating with 2 decimals, but I think that's only working because they have cents amounts where the "No care package option" doesn't at $13.00 even. Any ideas?

    Best,

    Natalie

  • Profile Image
    Richie_P
    Answered on April 12, 2019 at 03:18 PM

    I have checked your form and it seems that the calculation works and you have made the correct changes in your calculation.

    Here is how I view your form at my end.

    If the issue still remains, can you please explain further your calculation so that we can check?

  • Profile Image
    communications_gsrv
    Answered on April 12, 2019 at 03:26 PM

    Hi Richie,

    In the screen capture you sent you may notice that when you selected the "No, care package..." choice, there is only one decimal place showing($130.0) in the Order Total field. Wanting this to be ($130.00) instead.

    Thanks,

    Natalie

  • Profile Image
    EltonCris
    Answered on April 12, 2019 at 05:44 PM

    Using 2 decimal places won't work. On my test, both are treated as calculation. I would suggest using the decimal places option instead. It's under options in the calculation wizard as highlighted below.


  • Profile Image
    communications_gsrv
    Answered on April 16, 2019 at 11:05 AM

    Thank you EltonCris,

    I had this set to 2 decimal places already. When "No, care package..." choice is selected there is still only one decimal place showing($13.0) in the Order Total field. Wanting this to be ($13.00) instead.

  • Profile Image
    Richie_P
    Answered on April 16, 2019 at 12:26 PM

    Thank you for the clarification. Can you please follow my colleagues suggestion to use the option to show decimal places?

    Sample calculation:

    Sample screenshot of output:

    Sample Form:https://form.jotform.com/91015711712951

    Please give it a try and let us know if you have further questions.



  • Profile Image
    communications_gsrv
    Answered on April 16, 2019 at 02:37 PM

    My apologies Richie. With the directions provided I was able to get it working.

    Thank you for your patience with me!