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

    Showing 0 in blank/null - Based on dimension


      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,