1 2 Previous Next 19 Replies Latest reply on Sep 26, 2018 6:57 PM by Alexander Klandorf

    Display a Zero "0" When No Data

    Stephen Lanham

      Hi,

       

      I have a workbook with custom filters, when selecting one particular filter there is no data to display (not "null" data, no rows returned).  What I am trying to do is show the value of 0 when this occurs.  I have tried ISNULL and ZN, but these do not work because there is no data at all that is returning.  Any suggestions?  Below is a copy of the page

       

        1 2 Previous Next