- botesAsked on September 12, 2016 at 11:50 AM
I have created my basic form, put in the correct calculation which is working, but cannot get the decimals right in the total price box at the end. I've tried the input mask, but the decimals come out incorrectly when using the #.
Here is my form to see what I've done:
- JotForm SupportdavidAnswered on September 12, 2016 at 12:50 PM
I checked your form and I am currently seeing 2 decimal places in the calculation:
If you wouldn't mind letting us know what specifically is incorrect about the decimal places, we will be happy to have another look. The total does look to be correctly displayed at this time.
- botesAnswered on September 12, 2016 at 04:03 PM
Thanks for your reply. I can see I wasn't entirely clear. Yes, the decimal is there, however, if the total moves into double digits, for example, £25, the total is reflected as £1.50. I have played around with the # and decimal points and cannot get it to auto correct.
in the example you have posted above (5 articles at 350 words per article) according to the formula i have put in, the total should in fact be £87.50.
In summary, if the total is say £8.50 it is fine, however ,it is incorrect when the total enters double digits (£10 or more).
hope this makes sense...
- botesAnswered on September 12, 2016 at 04:09 PM
- JotForm SupportdavidAnswered on September 12, 2016 at 06:15 PM
Instead of using a condition, using a calculation widget:
This would require setting calculation values for your fields:
Here is how the form would function with the set up instead:
The calculation does produce the correct values. You can clone the form to your own account if you'd like to see the fully set up:
- botesAnswered on September 13, 2016 at 04:40 AM
That is a massive help and pretty much solved the problem. One last question - how do I get the £ or $ sign in the calculation box now?
- JotForm SupportEltonCrisAnswered on September 13, 2016 at 09:15 AM
Do you mean you want to take out the currency symbol?
If yes, it's found in your input mask field.
However, if you mean adding the currency symbol into the calculation field, just enter it manually before the formula in the calculation wizard.
- botesAnswered on September 13, 2016 at 09:53 AM
Thank you for the great support!