How to change the "negative" result of a calculation to "0"
This may seem like a beginners question (although I'm sort of a beginner), but I need to find out how to change the result of a calculation to "0" if the result is a negative integer.
Currently, the calculation field is set up as follows:
M Qty Left =
Qty - Sum ( Molding Data::Quantity )
The field (M Qty Left) is adding the total quantity (Qty) from a separate table (Molding Data) from multiple entries per order number and then subtracting that from the original order qty in the original table (Table). That part of the formula is working flawlessly, but sometimes we produce extra qty and that sends my calculation into a negative number and I need the field to show "0" for any negative integers.
Any help would be greatly appreciated.