AnsweredAssumed Answered

Help with substitute/list calculation

Question asked by tomhicks on Jul 22, 2015
Latest reply on Jul 25, 2015 by philmodjunk


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