7 Replies Latest reply on Jul 11, 2015 2:33 AM by kehumphr

    Custom Script for adding cells, but not displaying 0

    kehumphr Level 1
      Value 1Value 2Total
      5510
      6410
      0
      0

      I have cells, similar to above, that I want to calculate the total for, however the format in Adobe X means there will always be a zero in blank cells. I don't want that.

       

      I need a sum script that specifies if the answer is 0, to hide it.

       

      I tried searching around but couldn't get anything to work.

       

      Disclaimer, I am very new at this. I am looking to use the "Custom calculation script" box in Adobe, and I can use the Document JavaScript settings as well.