community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Sum of the Multiple fields in one new column

Meteoroid

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 NameABCD
Rahul10152035
Rajat15203540

 

Output:

Field NameABCDTotal
Rahul1015203580
Rajat15203540110

 

Your help is highly appreciated.

 

Regards,

Highlighted
Alteryx Certified Partner

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

Asteroid

Hi Mr Brown,

 

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

 

Mr_Brown_query.jpg

 

I hope this helps!

Alteryx Partner

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

clipboard_image_0.png

Asteroid

An even better solution!

Labels