Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I try to use this to create service column and but not all the values are getting populated ..and and not match condition value '0' getting displayed .. Any insight would really helps
if (match(Record_Type, ‘Authorized' AND Match(Sub_Type,'Appeal' )), 'Research' ,
if (match(Record_Type, 'PA'), ‘Determination' ,
if (match(Record_Type, ‘Information'), ‘Info',
if (match(Record_Type, 'Verification' ), 'Verification's',
if (match(Record_Type, ‘Authorization' AND NOT Match(Sub_Type,'Appeal' )), ‘Pre-Determination',
if (match(Record_Type, 'General’ AND Match(Sub_Type,'General Inquiry' )), ‘ Manager Inquiry',
if (match(Record_Type, 'Inquiry' AND Match(Sub_Type,'Detailed Inquiry' )), ‘Case Reviews',
if (match(Record_Type, 'Potential' ), Quality Report',
if (match(Record_Type, 'Commercial’), ‘ Assistance Program Enrollment',
if (match(Record_Type, ‘Step 1' AND Match(Sub_Type,'Coverage Follow Up' )), ‘Site of Care Follow up',
if (match(Record_Type, 'Copay' AND Match(Sub_Type,'New' ) ) ,'Pharmacy Activation' , '0'))))))))))) AS Service
Like this:
if (match(Record_Type, 'Authorized') AND Match(Sub_Type, 'Appeal'), 'Research',
if (match(Record_Type, 'PA'), 'Determination' ,
if (match(Record_Type, 'Information'), 'Info',
if (match(Record_Type, 'Verification' ), 'Verification's',
if (match(Record_Type, 'Authorization') AND NOT Match(Sub_Type, 'Appeal'), 'Pre-Determination',
if (match(Record_Type, 'General') AND Match(Sub_Type, 'General Inquiry'), 'Manager Inquiry',
if (match(Record_Type, 'Inquiry') AND Match(Sub_Type, 'Detailed Inquiry'), 'Case Reviews',
if (match(Record_Type, 'Potential'), Quality Report',
if (match(Record_Type, 'Commercial'), 'Assistance Program Enrollment',
if (match(Record_Type, 'Step 1') AND Match(Sub_Type, 'Coverage Follow Up'), 'Site of Care Follow up',
if (match(Record_Type, 'Copay') AND Match(Sub_Type, 'New'), 'Pharmacy Activation' , '0'))))))))))) AS Service
Well a simple error in use of single inverted comma...Just rectify it and your problem should be solved.I hope u r very much clear now
Like this:
if (match(Record_Type, 'Authorized') AND Match(Sub_Type, 'Appeal'), 'Research',
if (match(Record_Type, 'PA'), 'Determination' ,
if (match(Record_Type, 'Information'), 'Info',
if (match(Record_Type, 'Verification' ), 'Verification's',
if (match(Record_Type, 'Authorization') AND NOT Match(Sub_Type, 'Appeal'), 'Pre-Determination',
if (match(Record_Type, 'General') AND Match(Sub_Type, 'General Inquiry'), 'Manager Inquiry',
if (match(Record_Type, 'Inquiry') AND Match(Sub_Type, 'Detailed Inquiry'), 'Case Reviews',
if (match(Record_Type, 'Potential'), Quality Report',
if (match(Record_Type, 'Commercial'), 'Assistance Program Enrollment',
if (match(Record_Type, 'Step 1') AND Match(Sub_Type, 'Coverage Follow Up'), 'Site of Care Follow up',
if (match(Record_Type, 'Copay') AND Match(Sub_Type, 'New'), 'Pharmacy Activation' , '0'))))))))))) AS Service