cancel
Showing results for 
Search instead for 
Did you mean: 

Line Break in Formula

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Try this

if
{ODS_SALES_TYPES.CODE}='TP-REGH'
then
"Invoiced by the US to a US customer & shipped from a US Plant or"+chr(10)+ 
"Invoiced by Dagneux to a Customer in France and shipped by Dagneux"

Place this in the report and right click on the formula and go to format field and enable to option cangrow

Regards,

Raghavendra

Edited by: Raghavendra Gadhamsetty on Jan 29, 2009 6:34 PM

Former Member
0 Kudos

Excellent! That works. Thank you very much.

Answers (0)