4 Replies Latest reply on Feb 12, 2019 9:47 PM by Kashish Bhola

    Issue with placing 0 for null values in a dashboard containing multiple sheets

    niharika dharmani



      The dashboard has 6 sheets-- 2 sheets for states, 2 for -(total orders, ordervalues, ARPU and cancelled orders) and 2 for -(yesterday, PNDG and FC)

      The issue is that I am not able to place 0 for NULL values if there is not even a single value for a certain bucket in that particular sheet.

      For cases where there is atleast 1 value for a bucket in a sheet, 0 has been replaced by formatting and replacing special values.


      How can I replace NULL with 0 in his case?