AnsweredAssumed Answered

Help with a Substitution List based on a fields contents

Question asked by tomhicks on Dec 29, 2018
Latest reply on Dec 29, 2018 by comment

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 ) ; ¶ ; ", " )