Calculation widget giving wrong result.

  • UPROSA
    Asked on September 27, 2016 at 3:00 AM

    I have built a quotation form using Calculate widget. However the calculation is displaying a wrong value of 47, as seen in the screenshot.

     

    The actual calculation should result in 261*1.0*1.0*0.3*1.0 = 78.26. The actual quote is the product of the following values:

    Sub-category (Directory-Ad): 261

    Sze (1/4 page): 1.0

    Circulation(Up to 5,000): 1.0

    Time (Up to 1 day): 0.3

     

    Territory(Either US or EU): 1.0

    Jotform Thread 942638 Screenshot
  • Chriistian Jotform Support
    Replied on September 27, 2016 at 4:31 AM

    I checked your form and the calculation fields seems to be setup correctly so the result should have been correct. Please allow me some time to investigate this further and I will get back to you once I am done checking the form. Thank you.

  • Chriistian Jotform Support
    Replied on September 27, 2016 at 4:45 AM

    After checking further, it appears that the issue is related to the calculation values that you have on certain fields. You mentioned that the size of the 1/4 page should be 1.0, however, the calculation values on that field indicate that the 1/4 page is currently equal to 1.15.

    Calculation widget giving wrong result Screenshot 40

    Furthermore, your formula states that the Time for "Up to 1 day" is equivalent to 0.3, however, the calculation values currently in the form indicate that it has a value of 0.41.

    Calculation widget giving wrong result Screenshot 51

    The calculation values are incorrect, so the results are incorrect. To resolve this, simply update the calculation values to their appropriate values.

    Here's the result after I've updated the calculation values based on your specification.

    Calculation widget giving wrong result Screenshot 62

    Please let us know if you need further assistance.
    Regards.