Sum different columns with similar Column Name

[JJ747]

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

[CathyS_Slalom · Accepted 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.

[binu_acs]

@JJ747 one way of doing this