Good Morning. I am trying to add to fields together in a saved search by using formula(Numeric). This is what I have come up with so far {on_hand} + {on_order} but I get an Invalid Expression Error. How do you add two fields together using Formula(Numeric)
d
Dominic B
06/05/2023, 4:04 PM
Try wrapping the field names with NVL, ie. NVL({on_hand},0) + NVL({on_order},0)