Calculation Shows Inconsistent Results

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?

anybody out there please help me?

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.

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?

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.