Condition and Calculation Not Working Together

  • Profile Image
    dlasson
    Asked on August 19, 2015 at 12:43 PM

    Please see the section entitled "HealthCare FSA." For the field "Annual Healthcare Election," users will enter a numerical value (currency). If the value is LESS than $2550, I want the "Per Pay" field to perform its calculation. If the value is GREATER than $2550, I want the message (listed in the condition) to appear either in the "Annual Healthcare Election" field or the "Per Pay" field. 

    Also, the default "$" is not showing in the "Annual HealthCare Election" field.

    Duplicate issue in the next field, "Dependent Care FSA," the only change being that the maximum is $5000.

    Thanks!

  • Profile Image
    Charlie
    Answered on August 19, 2015 at 02:51 PM

    Hi,

    This is because you have a conditional logic for the rule greater than then you setup a formula inside the form calculation widget (Per Pay Healthcare). This is causing a conflict to what action to be done. You need to set a stricter and more straight forward action.

    I cloned your form for testing purposes, you can check how it works here: http://form.jotformpro.com/form/52305862245958 

    1. First, removed the formula in your form calculation widget for the field "Per Pay Healthcare...".

    2. Now use conditional logic to perform a calculation, we will use the same options to where you inserted the text for the maximum value, but in this case we will perform a calculation when the value is less than 2550. Below is the condition I setup, you'll notice I set a "Is equal to", this is because greater than and less than means it doesn't include the actual value. In this case, if the value IS 2550 and below then perform the calculation.

    3. Now here are the conditions for that specific field:

     

     

    Apply the same method in the other fields and the calculation should work.

     

    Regarding the follow up question on "$" not showing, I believe this is because you used the "Number" field, unfortunately, it doesn't accept non numerical values. You need to update that field to used a text box instead and set the validation to "Currency" then add a default value "$".

    However, this means you need to update the conditions you have already set.

     

    Do let us know if you need more assistance on this.

  • Profile Image
    dlasson
    Answered on August 20, 2015 at 11:58 AM

    Hi.

    Regarding the "$": If I change the field to "text box" as you suggested, I don't get numerical condition options (i.e. "greater than, less than") when I go to set up the conditions that I need.

    Thanks.

  • Profile Image
    dlasson
    Answered on August 21, 2015 at 03:06 PM

    For some reason, I cannot duplicate your solution. Specifically, the "Per pay Healthcare..." field is not computing.

  • Profile Image
    Ben
    Answered on August 21, 2015 at 04:11 PM

    In that case I would recommend simply cloning the form of my colleague: http://form.jotformpro.com/form/52305862245958

    That way you just do few clicks and you have the same form in your account - no extra steps ;)

    You can see how to clone it to your account by following the steps here: How to Clone an Existing Form from a URL

    Do let us know of course if you happen to have any further questions or issues and we would be happy to assist.

  • Profile Image
    dlasson
    Answered on September 09, 2015 at 12:50 PM

    Hi.

    http://form.jotform.us/form/52426685038157

    A condition is not working in one of my sections. Under "Voluntary Life"/ "Employee Coverage," I would like the "Max Coverage Amount Exceeded" field to appear if "Desired Coverage Amount" exceeds 500000. See the condition working for "Flexible Spending Accounts/ Healthcare" (though a different amount there).

    Thanks. 

  • Profile Image
    Charlie
    Answered on September 09, 2015 at 02:11 PM

    @dlasson

    Hi, it seems like this is a different concern with the original thread, I see it's a different form. For us to better assist you, I went ahead and opened a separate thread for it, please refer to this link instead: http://www.jotform.com/answers/658188. We will address it shortly.

    Thank you.