I have about a dozen tables in a new form that is working perfectly. Tables may contain positive or negative adjustments to static numbers. I need a field to calculate all of the fields that contain negative adjustments and another for positive adjustments.
I imagine some sort of "if then" statement will do this but I am not sure where to start.
Something like this maybe:
=if ChangeAmount <= 0 then ADD