Dynamically sum numeric columns

[Saravanan13]

Hello,

I am getting the below data after a join tool. I need to get sum of numeric columns(Red font) only. The columns might increase or decrease based on the joint results.

 I am getting error in the formula tool whenever new columns pop out of join tool or when columns gets reduced.

How to dynamically get the columns in a formula tool for getting the sum.

Total = EA+IA+JO+TEA+DND+RS+KC

NAME	EA	IA	JO	TEA	DND	RS	KC	%
ABC	4	0	1	1	1	1	2	100%
DEF	0	2	4	0	0	0	1	100%
GHI	0	2	0	3	0	0	1	100%
KJL	4	4	1	4	4	1	1	90%
MNO	3	2	2	6	1	2	1	83.30%
PQR	5	3	0	3	3	0	0	85.70%
STU	5	1	1	2	0	4	0	100%

[JosephSerpis · Accepted solution]

Hi @Saravanan13 you pivot your data using a transpose tool then use a summarise tool then use another join tool to join it back onto your data again. This way is your numeric columns exband or reduce it will always produce a sum.

[Qiu · Accepted solution]

@Saravanan13 
Just want to add that there is also an option in the Cross Tab tool we can do the Column Total, though we need to do something about the name columns, if you do care.

[flying008 · Accepted solution]

Hi, @Saravanan13 

Another dynamic solution for you, don't worry  about field name and order.

[PARESH]

Hi Joseph,

This is horizontal Sum, can you please show me, how do we perform vertical sum, if we have similar kind of data?

Thanks!