help with calculation
I need to merge a field if a condition is met. For example, I need to get all the email addresses from the students::mother_email_address field into one c field if the student is "special education"
I created the following relationship to get all the email addresses into one field using the List function
Students x Students_List_View
The calculation field I have is cEmailList=If(Students::List_View::Special_Ed="Yes";
However, the calculation returns all the email addresses... I only need those that meet the criteria.
Thanks in advance.