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

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


      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.