How to make calculation only when both conditions are true?

  • wolfpaw69
    Asked on April 6, 2016 at 4:25 PM

    I'm trying to make a calculation condition that basically needs two conditions to be met before it calculates.  

    First - If Termite Inspection is Yes

    Second - and Location is "Varying Location"

    Then calculated Travel Cost based on the two conditions above.

     

    Right now if Termite Inspection is NO, then the location is calculated.  Which it shouldn't unless Termite Inspection is Yes.

    The screen shot is from the emailed Notifier

    How to make calculation only when both conditions are true? Image 1 Screenshot 20

  • Ben
    Replied on April 6, 2016 at 5:36 PM

    I took a look at your form, but could not find "Varying Location" field, so I checked by doing the following:

    Location (Town or City) = Payson

    Payson Sub areas = Whispering Pines

    Termite Inspection = No

    Now looking at it I see that 25.00 is added to it - but it is as per conditions on your form.

    This is the one:

    How to make calculation only when both conditions are true? Image 1 Screenshot 20

    I do suggest checking it out on your form to disable it for the specific location that you do not wish that it is applied to, however if you wish that the condition matches each of the towns and that it is  0 if not termite selection, then you should add another condition that sets the field to 0 as long as termite selection is set to No and move it all the way up - above all other conditions.

    That way it should make sure that the field is 0 until needed otherwise.

    - My suggestion is to unhide the fields that you need to check and hide them only after everything is working right.

  • wolfpaw69
    Replied on April 7, 2016 at 11:48 AM

    For starters, it seems like you understand what I'm trying to do.  Good job.  Some times its hard to describe the issues.  

    Next, I did try putting the condition listed below but it didn't work.  It is at the top, I think.  Actually, it shows it at the top, but I'm not sure if this is actually happening.

    How to make calculation only when both conditions are true? Image 1 Screenshot 20

     

  • Welvin Support Team Lead
    Replied on April 7, 2016 at 1:03 PM

    That is because the NO is selected by default. Preselecting the option won't trigger the condition so you need to keep it open/unselected.

  • wolfpaw69
    Replied on May 1, 2016 at 8:11 PM

    Cool.  Thanks.  Looks like that worked.