2 Replies Latest reply on Mar 26, 2020 8:37 AM by Chulaxshan Gunasegaram

    Dashboard

    Chulaxshan Gunasegaram

      Hi experts,

       

      I am creating a continuous monitoring dashboard, i need to filter and get the number of records count if it comes 'Null',   '.' ,    ',,,'   values if not come want to show zero.

       

      i used this script , but it not show zero value

      IIF(ISNULL(LOOKUP(SUM([Number of Records]),0 )), 0, SUM([Number of Records]))

      if no any null or  values on basic i want to show

      Basic     Full

      0            3

       

      I attached the sample data set and workbook

       

      Appreciate if you guys help me to get this zero

       

       

      Thank you