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

    Force 0 to display when filtered

    Christian Song



      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 ?




      Best regards,