I could use some help trying to create a calculation field.
BACKGROUND: I have two fields. Field one, “Ounces Available”. Field two, “Footage Available”. Either one field or the other will have a value greater than 0, but not both simultaneously.
GOAL: To have one field show a NULL if the other has a value greater than 0.
RESULT: I’m able to create the calculation for one field, “Footage Available”. (Please see attachment, “Screen Shot 1”). However, after creating the calculation formula for the second field, “Ounces Available”, when I click on Save, Tap Forms leaves the room.
Could it be because I’m creating some sort of circular reference?
Attachment 1: Screen shot of first, successful calculation formula.
Attachment 2: Screen shot of second, unsuccessful calculation formula, right before clicking Save and Tap Forms blipping off the display.
NOTE: I can duplicate this issue consistently.
Attachments:
You must be
logged in to view attached files.