2 Replies Latest reply on Nov 23, 2018 4:48 AM by Nic G

    ISNULL not working

    Nic G

      Any idea why this is not working I want to highlight Nulls?  It does not put 'Yes' next to nulls ???


      IF ISNULL([Export Control Status]) THEN 'Yes'



      If I add "NOT" to the statement it recognizes non nulls.


      IF NOT ISNULL([Export Control Status]) THEN 'Yes'


        • 1. Re: ISNULL not working
          Jim Dehner

          Good morning Nic

          Can't tell without seeing your data but there are 2 types of nulls - one where there is a record with no data in it - and the other where there is no record for the combination of dimensions in the viz


          the 3 records in the rows 2-4 are an example of the second type - isnull will not find them - try using a lookup function like - ifnull(lookup(dimension),0,'Your string value') 

          Lookup is a table calculation that you will have to set up correctly depending on the dimensions in your viz


          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: ISNULL not working
            Nic G

            Thanks Jim, your correct I'd been playing with my Data Source.