5 Replies Latest reply on Apr 24, 2019 7:11 AM by albert wong

    Show 0 when there is no data

    Manish Virmani

      Hi All,

      We have a requirement to show 0 where if we dont have the data.


      I did tried to find out the solution, but no luck so far.

      Replacing No Data with 0 or Another Value


      When we select  'Bench' in the Status filter we should see 0. Please help. Workbook attached.


      I did tried ZN(lookup(Countd(Lead), 0)) and tried IFNULL() also.