Why is our form calculation showing characters instead of numeric values?

  • Profile Image
    Asked on March 27, 2018 at 01:31 PM


    Not sure why on the bottom calculation if two options are selected it sums but if one is added, it sums it but shows the equation. 15221718012018-03-27_10-29-07.png15221718212018-03-27_10-28-41.png

    How can I fix this?

  • Profile Image
    Answered on March 27, 2018 at 02:40 PM

    The reason it is showing these characters is because your calculation widget has the )+(0)+() characters passing data as string hence the error you are getting in your calculation. The calculation is also not correct based on the above.

    You will need to change the data to numbers as shown in the screencast below.

    1522175720calculation data.gif

    Below is my form with the above changes implemented.



    Kindly feel free to clone and use the form.


  • Profile Image
    Answered on March 27, 2018 at 03:43 PM
    No, the form you sent does not work either. I changed them to numbers and still getting error.

    Thank you,
    Deanna Eakin
    Trinitas Farming, LLC

  • Profile Image
    Answered on March 27, 2018 at 04:58 PM

    My colleague has already supplied the correct answer. Sometimes the form calculation fields can take a couple of tries before it works. For good measure make sure everything is numeric, and you press the green save button when you are ready.

    If that doesn't work then delete the field (as it is corrupted). And put your formula in again. Making sure its numeric and that the green save button is pressed.

    It should work. Keep trying.