3 Replies Latest reply on Apr 2, 2018 10:52 AM by Jim Dehner

    Replacing blanks with zeros

    sivasagar kalagara

      Hello Everyone,

       

      I am trying to replace blank with 0. In this case count(Document_Id) gives the number(137,132,..) according to statuses. I tried the below calculation they did not work. Is there any way to do it.

       

      Thanks in advance

       

      Regards,

      Sivasagar.

       

       

       

      IF

      count([Document_id])>1 THEN COUNT([Document_id])

      ELSE

      ifnull(COUNT([Document_id]),0)

      END

      ----------------

      iif(count([Document_id])>0,count([Document_id]),0)

      ------------------------------