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
Solved! Go to Solution.
Hi @anupgupta12
You can use summarize to get total(sum) and add it back to all rows using append tool
Hope this helps 🙂
Yeah! But I am looking for formula tool to this for me. is this functionality not available in FT?
Hi @anupgupta12
Formula tool works on single row level only. Hence no it cant be done in formula tool.