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'