Help - Form Not Following All Conditions

  • political
    Asked on August 22, 2014 at 12:22 PM

    Example: http://form.jotform.us/form/42319202042137

    when you apply 1100 you get a total... when you enter 2200 for second condition... it does not result in total... Condition is

    [WORKS] IF Voter Households Greater Than "0"
    AND IF     Voter Households Less Than "1251"
    Insert (({Voter Households}0.499)0.0825)+{Voter Households}0.499 into Total Cost (plus tax)
     
     
    [DOES NOT WORK] IF Voter Households Greater Than "1250"
    AND IF     Voter Households Less Than "2501"
    Insert (({Voter Households}0.449)0.0825)+{Voter Households}0.449 into Total Cost (plus tax)
     
    I can't find problem
     
    I've tried something else... thanks
    Page URL: http://form.jotform.us/form/42319202042137
  • Welvin Support Team Lead
    Replied on August 22, 2014 at 2:58 PM

    Hi,

    It's a conflict to the conditional logic list. I would suggest removing the AND IF LESS THAN rules and add IF GREATER THAN into a series. For example:

    If Voter Households Greater Than 0

    If Voter Households Greater Than 1251

    If Voter Households Greater Than 1500

    So looking into this way, the calculation works based on the value provided. IF the Voters Household is 1250, it calculations condition based on the entry for "Greater Than 0". The same if Voters Household is 1499, it calculates the condition based on the entry for "Greater Than 1251" and son on..

    Thank you!