AnsweredAssumed Answered

calculation to list field contents if not empty

Question asked by kilbot on Oct 31, 2011
Latest reply on Oct 31, 2011 by bumper

Title

calculation to list field contents if not empty

Post

Okay I would like to write a calculation that would look at a field and get it contents followed by a comma and space unless it is empty, whereas I would want it to grab nothing. How could I write this

 

exampl:

Field 1            Field 2         Field 3

apple                                carrot

 

Calculation would return

apple, carrot

 

Thanks

Outcomes