Skip to Content
0
Former Member
Jan 29, 2009 at 05:29 PM

Line Break in Formula

20 Views

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