5 Replies Latest reply on May 16, 2019 1:19 PM by Norbert Maijoor

    Force 0 to display when filtered

    Christian Song

      Hello,

       

      I did a text table with 2 dimension and [Number of Records].

       

       

      I created a calculated field as NullTo0: ZN(LOOKUP(SUM(IFNULL([Number of Records],0)),0)) in order to force to display the "0"  in the table above.

       

      But when i put a filter on a Team, the 0 is not displayed:

       

       

      Is there anyone who has a solution to display 0 when the table is filtered ?

       

      Thanks,

       

      Best regards,

       

      Christian