Calculation widget giving wrong result.

  • Profile Image
    Asked on September 27, 2016 at 03: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

  • Profile Image
    Answered on September 27, 2016 at 04: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.

  • Profile Image
    Answered on September 27, 2016 at 04: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.

    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.

    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.

    Please let us know if you need further assistance.