I have 4 Columns named as Base Pay , Base Pay 1 , Base Pay 2 , Base Pay 3 and I wanna add the sum of all these 4 columns to a new column say Base Pay 5.
Any insights
Solved! Go to Solution.
Hi @JJ747, you can use formula tool and add them together:
If you have many columns and want to sum them together, I would recommend to use dynamic select to select columns based on the pattern, then transpose the selected columns --> then summarize it
See attached workflow for details.