I need help with a calculation regarding a substitution list.
This is the calculation as I have it written now which works fine for "listing"
Substitute ( List ( PARTIES::Name Full ) ; ¶ ; ", " )
But now I want to make it only list the fields contents if another field text contains specific text. I tried placing in an IF and CASE statement but I failed and could now use a little help please
Substitute ( If ( JT_01_CASES_PARTIES::Party Type = "complainant" ; List ( PARTIES::Name Full ) ; ¶ ; ", " )