5 Replies Latest reply: Jan 18, 2017 7:28 AM by Eduardo DImperio RSS

    Working with null results

    Eduardo DImperio

      Hey !

       

      I was working in the grafic part and my table return some null values and its ok, but i want to chance null for zero  to numeric fields and 'Nao Consta' to string fields.

       

      So I did this:

       

      If (Isnull(CLIENTE), 'NAO CONSTA',CLIENTE)


      And works to Cliente Field, but for my ENTRADA_DESENV, doesn't.


      i.e


      If (Isnull(ENTRADA_DESENV), 'NAO CONSTA',ENTRADA_DESENV) - Not Work


       


      If (Isnull(ENTRADA_DESENV),0,ENTRADA_DESENV) - Not Work


      Any ideia why?


       


      Thank You.

      Null_Value.JPG