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!
Solved! Go to Solution.
hI @dmpope,
Use the formula tool and inside of it write '92303'. You will populate 92303 in all the values in that column.