2 Replies Latest reply: Aug 31, 2017 4:01 PM by Robert Winkel RSS

    If(isnull( ClassCd

    Robert Winkel

      I have two fields I need to populate ClassCd nulls with MOP

       

      Pivot Table

       

      This part works great.

      =If(wildMatch(ClassCd, '01', '04','05'), 'Commercial',   

      If(wildMatch(ClassCd, '02'), 'Medicaid',

      If(wildMatch(ClassCd, '03'), 'Med D',

      If(wildMatch(ClassCd, '06'), 'Hospice',))))

       

      I need to populate the nulls with what is in field MOP

       

      The three nulls needs to roll into two

       

      FACI should be 'Facility'

       

      GUAR , PRIV should be 'Private'