AnsweredAssumed Answered

How to change the "negative" result of a calculation to "0"

Question asked by DavidBradow on Aug 30, 2012
Latest reply on Aug 30, 2012 by DavidBradow

Title

How to change the "negative" result of a calculation to "0"

Post

Hello,

 

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.

Outcomes