4 Replies Latest reply on Feb 5, 2016 12:08 PM by try67

    How do you remove a zero value in a Calculated Field?

    slabby

      I have a calculated field that multiplies the unit price with quantity. But the total field has a zero in it if either field is zero.

      I need to remove that zero from the calculated field.

       

      Currently have the calculated field as:

       

      TotalPrice = Qty1 * UnitPrice

       

      Need to have TotalPrice blank if fields have a zero in it.

       

      Thanks.