Is there a way to insert a carriage return in text in a formula? I have a formula which shows certain text based on what is contained in another field. I want 2 separate lines in the text. Is there a way to do this?
For example,
if
{ODS_SALES_TYPES.CODE}='TP-REGH'
then
"Invoiced by the US to a US customer & shipped from a US Plant or
Invoiced by Dagneux to a Customer in France and shipped by Dagneux"
Thanks,
Kathy