1 Reply Latest reply on Dec 9, 2016 12:20 PM by try67

    Negative number after calculation showing 0

    shawncox

      I am creating an inventory form that has columns of Par, QOH and Amount to Order

       

      Field Names

      P1 | Q1 | O1

      ___________

      P1 - Q1 = O1

      Par # - Quantity on Hand # = Amount to order

       

      Example:

      If par is set at 6 and QOH is 4 we need to order 2. [6-4=2]

      BUT, if par is set at 6 and QOH is 8 we do not need to place an order but the output is negative (-2). [6-8=(2)]

       

      How do I make the output show zero when the calculation shows a negative answer?