Help with substitute/list calculation
I'm trying to write the calculation that if CORRESPONDENCE::id_party = "Complainant"
Then make a list of the of names separated by commas, i.e. List (CORRESPONDENCE::name_full ; ¶ ; ", " )
But with the calculation I wrote (below) it states I do not have enough parameters. This tells me I have incorrectly written this calculation. If you could help and explain so I could hopefully understand the correct calculation I would appreciate it.
Substitute (If (CORRESPONDENCE::id_party = "Complainant");List (CORRESPONDENCE::name_full ; ¶ ; ", " ); )))