1 2 Previous Next 18 Replies Latest reply on Dec 7, 2018 8:59 AM by sindhu gullapalli

    Substituting 0 when we 'Show Empty Rows' option ?

    tholkappian.vadivelu

      How do I substitute 0 when there is no value in Sum[Number of Records] field. I was able to show the rows using 'Show Empty Rows' option but I would like to replace the NULL with 0. I have Sum[Number of Records] in column shelf which is where I want to substitute 0.

       

      I came across ZN and Lookup functions but I am not able to use them in the Number of records field. Am I missing something ?

       

      Appreciate your help.

       

      Thanks

        1 2 Previous Next