The Form is not calculating correctly

  • odm111
    Asked on July 4, 2019 at 5:49 AM

    Hi there

    The circled field in Screenshot 2 is calculated with the Form Calculation shown in Screenshot 1.

    Screenshot 1

    1562233121Capture3 Screenshot 10

    Screenshot 2

    1562232985Capture1 Screenshot 21

    If the "Do you want these bundled for a distributor" field is not equal to "Bundled into lots of 200" then the circled $ field should equal 0 as specified by the condition shown in Screenshot 3 below.

    Screenshot 3

    1562233411Capture4 Screenshot 32

    However 0 is being calculated when the opposite is true.

    Screenshot 4

    1562233538Capture2 Screenshot 43

    Can you please tell me what I've done wrong here? Thank you.

  • roneet
    Replied on July 4, 2019 at 7:22 AM

    Please allow me some time to study the calculation set up here.

    Thanks

  • roneet
    Replied on July 4, 2019 at 8:14 AM

    Since you have put calculations in the Form Calculation widget by default so it is not calculating correctly and taking some default values. You would have to put the calculations conditionally.

    Also, use the short text entry field for the "$" field.

    Here, in my test Form, I have put a textbox and then conditionally calculating the formula and inserting value to this text box.

    The Form is not calculating correctly Image 10

    Here are the two conditions I have added in my demo Form:

    The Form is not calculating correctly Image 21

    Feel free to test my demo Form:

    https://form.jotform.com/91842986220967

    Let us know if you have further questions.

    Thanks.

  • odm111
    Replied on July 15, 2019 at 7:27 AM

    Thank you so much for your help! Really appreciate it. Using conditions to calculate a field's value rather than the Form Calculation widget solved my problem.