How to make calculation only when both conditions are true?

  • Profile Image
    Asked on April 06, 2016 at 04: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

  • Profile Image
    Answered on April 06, 2016 at 05: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:

    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.

  • Profile Image
    Answered on April 07, 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.


  • Profile Image
    Answered on April 07, 2016 at 01: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.

  • Profile Image
    Answered on May 01, 2016 at 08:11 PM

    Cool.  Thanks.  Looks like that worked.