Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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