4 Replies Latest reply: Jul 31, 2014 4:30 AM by Charlotte Gilbert RSS

    Replacing Null

      Hi

       

      I have a Table like below :

       

      AGENTID

      LEID
      1TN31Q8429
      2-
      3-
      4
      5TN31Q8433
      6TN31Q8434
      7
      8
      9
      10

      TN31Q8438

      I want to display a chart , if there is a value in LEIID , then its 'available' , if no value (Which includes -)'Missing'

       

      How to achieve it