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.
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.
Retrieving data ...