tcwaters

Substitute isn't differentiating between a 1,10, and 11

Discussion created by tcwaters on Apr 21, 2017
Latest reply on Apr 24, 2017 by TomHays

I'm having a problem with this calc field:

 

Substitute ( linked_Outcomes;

["1" ;  TextStyleAdd ("      PittPharmacy Outcome 1: Learner" ; Bold)];

["2" ;  TextStyleAdd ("      PittPharmacy Outcome 2: Patient Assessor" ; Bold)];

["3" ;  TextStyleAdd ("      PittPharmacy Outcome 3: Caregiver" ; Bold)];

["4" ;  TextStyleAdd ("      PittPharmacy Outcome 4: Manager and Leader" ; Bold)];

["5" ;  TextStyleAdd ("      PittPharmacy Outcome 5: Health Promoter and Provider" ; Bold)];

["6" ;  TextStyleAdd ("      PittPharmacy Outcome 6: Preparer and Dispenser" ; Bold)];

["7" ;  TextStyleAdd ("      PittPharmacy Outcome 7: Problem Solver" ; Bold)];

["8" ;  TextStyleAdd ("      PittPharmacy Outcome 8: Educator and Communicator" ; Bold)];

["9" ;  TextStyleAdd ("      PittPharmacy Outcome 9: Professional and Advocate"; Bold)];

["10" ;  TextStyleAdd ("      PittPharmacy Outcome 10: Collaborator"; Bold)];

["11" ;  TextStyleAdd ("      PittPharmacy Outcome 11: Life-Long Learner and Innovator" ; Bold)]

)

 

What happens, is if the "linked_Outcomes" has a 10, the calc produces"

PittPharmacy Outcome       PittPharmacy Outcome 1: Learner0: Collaborator

Outcomes