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% |
Solved! Go to 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.
@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.