1 Reply Latest reply on Dec 12, 2016 10:27 AM by philmodjunk

    Total Cost Based on menu item

    AlexOrrow

      Hi,

       

      I'd like a total cost field to calculate (quantity * cost = Total) only when a checkbox field is marked as yes.

       

      I thought an if statement would do this but I cannot seem to get it to work.

       

      Any help much appreciated. Thank you.

       

      Alex

        • 1. Re: Total Cost Based on menu item
          philmodjunk

          assuming that your check box field has a single check box and is of type text:

           

          If ( CheckboxField = "yes" ; quantity * cost = Total )

           

          Should work. If your checkboxfield has multiple check boxes then you have to use a more sophisticated check to see if "yes" is one of the multiple options selected.

           

          Note also that a check box format can hide other data present in the field and this can keep your CheckboxField = "yes" expression from being true.