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


    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