Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Formula Tool

anupgupta12
8 - Asteroid

Hi There,

 

Please suggest a formula to a add new column for the total of an existing column.

 

e.g.

 

Col1

50

100

50

 

Expectation

Col1 COl2

50      200

100    200

50      200

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @anupgupta12 

 

You can use summarize to get total(sum) and add it back to all rows using append tool

atcodedog05_0-1621150896413.png

Hope this helps 🙂

anupgupta12
8 - Asteroid

Yeah! But I am looking for formula tool to this for me. is this functionality not available in FT?

atcodedog05
22 - Nova
22 - Nova

Hi @anupgupta12 

 

Formula tool works on single row level only. Hence no it cant be done in formula tool.

Labels