Replacing V_String with a different string/label

[dmpope]

Hi there,

I have a set of reports with account numbers that I need to either replace or label with the group code 92303 in a new column. I know I can add a new column through the formula tool, but I'm not sure which formula(s) to use? The Account Numbers are a V_String (if that helps) because I was using them to group by in the summarize tool. Below is an example of what I have currently and what I'm looking to do:

Account Number       Amount  

1111                            1.00

2222                          -2.00

3333                           3.00

4444                          -4.00

vs

Account Number       Amount       Group Code

1111                            1.00             92303

2222                          -2.00             92303

3333                           3.00             92303

4444                          -4.00             92303

Thank you!

[Emil_Kos · Accepted solution]

hI @dmpope,

Use the formula tool and inside of it write '92303'. You will populate 92303 in all the values in that column.