decode on object report
By Beverly Lauby
October 27, 2017

I have been working on this for 2 days and had any success.  All help appreciated.

At our High School we have 0 period and 0-1 (meets for 2 periods) period classes.  But not all students take a 0 period class.  On our report cards I want to pull the teacher name for either the 0 period or 0-1 period class, but if there is no class taken I want "No period 0 class taken" to pull.

This is the code but it is not working.
^(decode;^(*period_info;0(A);teacher_name); ;
^(decode;^(*period_info;0-1(A);teacher_name); ;
No Period 0 course taken;^(*period_info; 0(A);teacher_name)^(*period_info;0-1(A);teacher_name))

What am I doing wrong?

Thanks,
Bev Lauby
Lexington Public Schools