Help Adding Underscore At End of Number

[loizza]

Hi, I have a set of account numbers that I need to add an underscore to the end of, so 1234 to show as 1234_ I recall doing this a while ago but cannot remember how, I know it ended & "_" as .... but cannot remember? I've look online, but cannot find the solution? Any suggestions please?

[barnabyd]

G'day @loizza,

For string literals, we use single quotes. So it is  & '_' . Double quotes are used for field names.

Cheers, Barnaby.

[Aditya_Chitale]

Try doing:

<your account number field>  &  '_'  as  [New account Num Field]

Regards,

Aditya