Formula Tool

[anupgupta12]

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

[atcodedog05 · Accepted solution]

Hi @anupgupta12 

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

Hope this helps 🙂

[anupgupta12]

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

[atcodedog05]

Hi @anupgupta12 

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