AnsweredAssumed Answered

help with calculation

Question asked by truji_ on Apr 25, 2012
Latest reply on Apr 25, 2012 by philmodjunk

Title

help with calculation

Post

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";
Let([
x=List(Students_List_View::mother_email_address)];
Substitute(x;"¶";","));"")

However, the calculation returns all the email addresses... I only need those that meet the criteria.

Any ideas?

Thanks in advance.

Outcomes