Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

formula to combine multiple fields on one column

Hi All,

How do you create a formula in the formula editor that allows you combine several fields onto one column. An example: if I wanted to combine a street address onto one column when it is several fields in the data base. I know I need to seriously work on my coding, because it probbably is not that difficult. I've tried slect statementw with Case True and different If then else statements, but I am not getting all of value to return.


Former Member

Hi Kyle,

To avoid null values you need to convert "Default values for nulls" in the formula editor.

Edit your formula

{database.field1} + " " + {database.field2} + " " + {database.field3}

and in formula editor at the top you can see a dropdown list with "Exception for nulls" change this and select "Default values for nulls"

Now you can avoid the nulss in output



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question