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

    Checking Length of Field

    Thomas 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?



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


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


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