Good Morning. I am trying to add to fields togethe...
# suitescript
k
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
Try wrapping the field names with NVL, ie. NVL({on_hand},0) + NVL({on_order},0)
k
@Dominic B I will try that
Thank you so much that working @Dominic B