What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Calculation Shows Inconsistent Results

    Asked by ballareinternational on February 10, 2015 at 09:39 PM

    Hi,

     

    Here is my form.

    http://form.jotform.me/form/50404330637446

    For example, When i make the following selections, 

    I get the following results:

    The Grand Total Cost does not tally with the accurate one, which is 180. (Final Cost (Standard) + Final Cost (Latin))

     

    This is however, not consistently wrong throughout other selections, as some as still accurately calculated. How do i solve this?

    Page URL:
    http://form.jotform.me/form/50404330637446

    calculations JotForm uploads png tally
  • Profile Image

    Answered by ballareinternational on February 11, 2015 at 02:02 AM

    anybody out there please help me?

  • Profile Image
    JotForm Support

    Answered by Charlie on February 11, 2015 at 09:44 AM

    Hi,

    I believe this is because of how you setup your conditions. Each field depends on what is selected, but the problem is that there's a conflicting fields with your conditions and also the conditions' priority also causes a problem. So let's say you selected options A, B and C, in an order of 1, 2, 3 respectively, but when you try to select them by C, B, A the value of the total will be different. This is because of how you have setup your conditions.

    Also, upon checking your hidden fields, I see that they have duplicate conditions, see this sample screenshot below. You'll see the other one is disabled (I disabled it), and the other one is enabled. You have a lot of duplicate conditions that causes inconsistencies. 

     

    I would suggest that you check your fields again, it would be better if you filter each field to see the conditions specific to them, you'll see duplicates when you do that. Here's a sample screenshot, choose a field and click the conditions on it, you'll see all the conditions associated to it and if there's a duplicate.

    I hope this helps.

    Thank you.

  • Profile Image

    Answered by ballareinternational on February 11, 2015 at 11:06 AM

    Hi Charlie,

    Thanks for your help once again. I have removed all my duplicate entries and here is the updated form:

    http://form.jotform.me/form/50404330637446

     

    However, my main issue still remains with the selection of the following:

     

    My intended result of 180 is accurately depicted in "Total Cost (Latin)", but is depicted wrongly as "80" in the Grand Total Cost. Why is this the case?

     

  • Profile Image
    JotForm Support

    Answered by Charlie on February 11, 2015 at 11:52 AM

    Hi,

    You can check this edited cloned form that I have: http://form.jotformpro.com/form/50414942351954?

    But please do take note that the only edited cases that I made are the following:

    If Standards Events selected are the following:

    Pre-Amateur (W,T,Q)

    Novice A (W,Q)

    Novice B (T,SF

    If Latin Events selected are the following:

    Pre-Amateur (C,S,R)

    Novice A (C, J)

    Novice B (C,R)

     

    The total in my case works because all the rules are covered. Here's an example of yours

    Condition 1:

    If Latin Events is Equal To Pre-Amateur (C,S,R) AND If Latin Events is Equal To Novice B (C,R)

    then perform an insert -60 To Latin Total Adjustments (Pre-Am/Novice A/Novice B)

    Condition 1 will have a lot of problems, if 2 of it's rules are TRUE regardless if other options are also selected in the options it will cause a problem in giving a correct insertion of the value in the output.

    To improve or correct this you should have a negative approach to avoid conflicts, to give correct values to the field Latin Total Adjustments (Pre-AM/Novice A/Novice B) you should correct the conditon like this:

    Condition 1 Improved:

    If Latin Events is Equal To Pre-Amateur (C,S,R) AND If Latin Events is Equal To Novice B (C,R) AND If Latin Events is NOT Equal To Novice A (C, J)

    then perform an insert -60 To Latin Total Adjustments (Pre-Am/Novice A/Novice B)

    This should make a more accurate insertion and more clearer rules and action to perform. This means that you should also cover all possible conditions and make a break point, in this case a NOT EQUAL TO rule. 

    I hope this helps. I know it's quite confusing.

    Thank you.