Concatenate First Name & Last Name

[former_member629678]

Hello,

I am trying to concatenate the First Name & Last Name in BOE Report. I am creatin the variable, and I get this incorrect formula error. Please help me fix it .

=Concatenation([All CPQ origin Orders].[Contact First Name][All CPQ origin Orders].[Contact Last Name]).

Thanks for help.

[mhmohammed]

Hi SJ,

Try this

=[All CPQ origin Orders].[Contact First Name] + " " + [All CPQ origin Orders].[Contact Last Name]

Thanks,
Mahboob Mohammed

[former_member636715]

This is what I use as well, it gives more control to use whatever you want in between. + " " + or + ", " + etc