can we have a formula tool to refer multiple field (especially dynamic as well)
![Pang_Hee_Choy_6-1634812704066.png Pang_Hee_Choy_6-1634812704066.png](https://community.alteryx.com/t5/image/serverpage/image-id/207532iCFCC97725FC81F80/image-size/medium?v=v2&px=400)
i KNOWN we can use transpose and crosstab tool. but it silly to do one thing with two tool.
Problem
To sum all the fields in the file. so now is A-D.
![Pang_Hee_Choy_1-1634811729918.png Pang_Hee_Choy_1-1634811729918.png](https://community.alteryx.com/t5/image/serverpage/image-id/207524i0FA5BC479D2A4C66/image-size/medium?v=v2&px=400)
I can use formula tool to do it. easy. But, what if fields add / delete frequently?
![Pang_Hee_Choy_2-1634811746685.png Pang_Hee_Choy_2-1634811746685.png](https://community.alteryx.com/t5/image/serverpage/image-id/207525i7410DC2A72ACA688/image-size/medium?v=v2&px=400)
Now, it sum A-E, what if G-F tomorrow, and B-Z after tomorrow, i do not want to update workflow every time.
![Pang_Hee_Choy_3-1634811821262.png Pang_Hee_Choy_3-1634811821262.png](https://community.alteryx.com/t5/image/serverpage/image-id/207526i5C25C8AF109130D0/image-size/medium?v=v2&px=400)
suggestion :
I hope we have a tool that similar to multiple field tool, but it output to a new field only.
![Pang_Hee_Choy_5-1634812692162.png Pang_Hee_Choy_5-1634812692162.png](https://community.alteryx.com/t5/image/serverpage/image-id/207531i93B85444401740D5/image-size/medium?v=v2&px=400)
I KNOWN SUM() is not alteryx function but just an example. we can expand further other formula for string and date.