2 Replies Latest reply on Feb 12, 2016 5:43 AM by pooja.gandhi

    Calculated fields/Replacing a zero with a blank

    Eric Horio

      Hello,

       

      I have two questions:

       

      1) I'm having a problem with a calculated field. I created a calculated field called "Pipe Open", which is the "Pipe Created" - "Pipe Won". However some of these calculations are not working properly, as I'm getting all zeros. Is it the way the formula is constructed?

       

      2) If the calculation is in fact a zero, how can I replace the zero value with a blank?