Order Total not displaying 2 decimal place for a currency value

  • communications_gsrv
    Asked on April 10, 2019 at 4: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?
  • Alan_D
    Replied on April 10, 2019 at 4: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. Order Total not displaying 2 decimal place for a currency value Image 10Order Total not displaying 2 decimal place for a currency value Image 21

  • communications_gsrv
    Replied on April 12, 2019 at 1: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

  • Richie JotForm Support
    Replied on April 12, 2019 at 3:18 PM

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

    Order Total not displaying 2 decimal place for a currency value Image 1 Screenshot 30

    Here is how I view your form at my end.

    Order Total not displaying 2 decimal place for a currency value Image 2 Screenshot 41

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

  • communications_gsrv
    Replied on April 12, 2019 at 3: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

  • Elton Support Team Lead
    Replied on April 12, 2019 at 5: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.

    Order Total not displaying 2 decimal place for a currency value Image 1 Screenshot 30

    Order Total not displaying 2 decimal place for a currency value Image 2 Screenshot 41


  • communications_gsrv
    Replied 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.

  • Richie JotForm Support
    Replied 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?

    Order Total not displaying 2 decimal place for a currency value Image 1 Screenshot 40

    Sample calculation:

    Order Total not displaying 2 decimal place for a currency value Image 2 Screenshot 51

    Sample screenshot of output:

    Order Total not displaying 2 decimal place for a currency value Image 3 Screenshot 62

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

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



  • communications_gsrv
    Replied on April 16, 2019 at 2:37 PM

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

    Thank you for your patience with me!