14 Replies Latest reply on Nov 7, 2013 10:13 AM by Matthew McLaughlin

    How to exclude NULL value

    philip ken

      Hi all,

      I have a data base table field REGION.STATE has NULL (blank value). I would like to create a Calculated field (this is must) such way that it exclude NULL (blank value). How to do this?

      Current Table value.

      MD

      NY

      OH

      <NULL> (blank)

      I want in Calculated field as below:

      MD

      NY

      OH

      Thanks in advance