Help Adding Underscore At End of Number

[driplpent]

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?

[AshutoshBhumkar]

Hello,

Yes, you are right. Just append the underscore at the end of the dimension. (This will just convert your dimension format from number to text)

[Account Number]&'_'

E.g :

Thanks,
Ashutosh