Using only one "Formula Tool" to find percentages of each value in the list

Question

I have 5 students and their exam results (total of results is 400). I want to calculate the percentage of each student's result. Is there any formula like this: [result] / SUM [result] in Formula tool?

I can do it using Append tool, but I wonder is there anyway to do in Formula tool?

BrandonB · Accepted Answer

The way that I have always done these calculations is to use a summarize tool and append the value on to each row of the original data with a formula tool after to perform the calculation as you mentioned

The reason for this is that although Alteryx operates on entire columns at one time, the functions operate on each row of data. Technically you could do this with a running total, a sort from largest to smallest on the running total, a subsequent multi row tool that sets every value to the row above it effectively making each value of the column the same as the sum of the other column. This requires more tools, however, and isn’t as efficient.