7 Replies Latest reply on Dec 15, 2016 5:29 PM by sherry.shaik

    Calculation for categorizing with conditions

    sherry.shaik

      Hi all,

      can someone help in creating calculated field for categorizing comparisons between two systems?

      1WorksIf field1 & field2 matches
      2Doesn't worksIf Field1 & Field2 doesn't matches(No Nulls considered)
      3BOTH NULLSIf both Field1 & Field2 are NULLS
      4Field1 NULLIf Field1 is Null & Field2 is NOT NULL
      5Field2 NULLIf Field2 is NULL & Field1 is NOT NULL

      Thanks

      Shinichiro Murakami