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

    Total Cost Based on menu item




      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.



        • 1. Re: Total Cost Based on menu item

          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.