11 Replies Latest reply: Apr 12, 2012 7:42 AM by Thom Mumaw RSS

    Checking Length of Field

    Thom Mumaw

      I am trying to set an indicator based on values in a field.  I have tried all of the following with no luck.  Any ideas?

      Thanks
      Thom

       

      If (IsNull(KVGR4),1,0) as Organic

       

      If Len(KVGR4 > 0,1,0) as Organic

       

      If (Len(Trim(KVGR4) > 0),1,0) as Organic