Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

New Total Column

neromerob
10 - Fireball

Hello. 

 

I´m working on a workflow at the moment and I´m trying to produce a new Column with the sum total of the values that exist in the row. 

 

sum_column.jpg

5 REPLIES 5
IraWatt
17 - Castor
17 - Castor

Hey @neromerob,

this workflow can do this:

IraWatt_0-1655912899146.png

Any questions or issues please ask :)
HTH!
Ira

 

suby
11 - Bolide

Hi,

 

Please find the attached the WF.

 

Thanks

DataNath
17 - Castor

Here's two ways. If you're keen to optimise and just use a single tool then there's an 'Add Totals' macro in the CReW macros pack which you can download here: http://www.chaosreignswithin.com/p/macros.html

 

 

DataNath_0-1655913080855.png

 

AmalinaH
Alteryx
Alteryx

The simplest way is to use a formula tool to create a new field for TOTAL. You can use an addition formula  where


TOTAL = [from_1_to_10]+[from_11_to_20]+[from_21_to_30 ]

 

If you would like the new column to appear after NAME you can use the Select tool to shift it.

 

AmalinaH_0-1655916143656.png

 

IraWatt
17 - Castor
17 - Castor

I agree with @AmalinaH, the formula tool is the way to go 😅

Labels