Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
I am trying to calculate the Tie of a pallet, but the search returns an error if the width field is
Hello,
I am trying to calculate the Tie of a pallet, but the search returns an error if the width and/or depth field is blank.
The following formula works, but if these fields are not populate the search will return an error. I am concerned that a NULLIF will not work, as that would mean I was dividing by "0".
FLOOR (1920/({custitem_width}*{custitem_depth}))
Any assistance would be appreciated ,as SQL is not my thing.
Kristin
Tagged:
0