Sum of the Multiple fields in one new column

Question

Hi Team,

I am trying to total 30 columns in the new columns. Further If you could provide the solution apart from expression: "[A]+[B]+[C]+[D]".  For example Data is

Input:

Field NameABCDRahul10152035Rajat15203540

Output:

Field NameABCDTotalRahul1015203580Rajat15203540110

Your help is highly appreciated.

Regards,

LordNeilLord · Accepted Answer

Hey @Mr_Brown

Easiest way is to transpose (grouping on name) the use summarize to sum Value (grouping on name again)

Then you can join your results back on to your original table

Dazzerman · Accepted Answer

Hi Mr Brown,

Here is a module that will calculate the values in the format you're looking for.

I hope this helps!

🙂

OllieClarke · Accepted Answer

Hi @Mr_Brown, The Cross Tab tool has a 'Total Column' aggregation method which will do what you want: