3 Replies Latest reply on Jul 30, 2018 7:13 AM by giulia.bartoletti

    Showing 0 in blank/null - Based on dimension

    giulia.bartoletti

      Hi everyone,

       

      I am having a lot of problem with showing 0 instead of blank.

      I tried everything:

       

      - ZN

      - ifnull

      - IF isnull(amount) then    0 else amount

      - countd(measures)+0

      - Lookup

      - Adding zero in the format

       

      Basically what i would like is to have all different of SLA Status (dimension) and in case in null/blank showing 0.

       

      In the dashboard should look like this, but the empty space should have 0. Every worksheet needs to be filter based on what i am showing (SLA Missing or SLA Past):

       

      Example Null.PNG

       

       

      Can someone please help me to resolve this problem? Attached an example.

       

      Thank you very much for your help,

       

      Giulia