How to add a new line to sum of the values ​​from column 1 to 4

[Sakiko]

Hi There,

How can I add a new line to sum of the values from column car1 to column car4?

I need your help!

[BenMoss · Accepted solution]

Just want to clarify that given the example data it seems you actually want a total column not row is that correct?

A couple of ways to achieve this.

First of all you can use a standard formula tool and 'add a field', which would be...

[Car1]+[Car2]+[Car3]+[Car4]

Note for this to work you would have to replace any NULL values with zeros, this can be done easiest using the data cleanse tool.

Alternatively, and in a more dynamic manner (say if the number of columns changed or more [car] fields were added, you could transpose your data and then use a summerize tool before joining back, as shown in the below image.

I've attached an example workflow with both methods.

Ben

[ponraj · Accepted solution]

Attaching a sample workflow for your case.  Hope this is helpful. 

[Sakiko]

Hi Ben,

Thank you for your professor in two detailed procedures.
I solved it thanks, and I can use it in another case in the future as well.
Thank you.

Sakiko 

[Sakiko]

Hi Ponraj,

I was able to solve it by using the work that you offered.
I appreciate quick response as well.
Thank you.

Sakiko