What is the formula to show Non-Exclusive Choice values from a TouchPoint element on separate lines within a table cell, instead of having them separated by pipes?
If in the Flattened TouchPoint folder, the Non-Exclusive Choice element has the corresponding Results Object, "[Question_X]", one could use the following formula to remove pipes, and separate values by lines:
Using this formula, the values that previously displayed as:
- Answer A|Answer B|Answer C|Answer D|
Will now show as:
- Answer A
- Answer B
- Answer C
- Answer D
For more information on how to create an ETO Results formula click here.