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

    Negative number after calculation showing 0


      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



      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?