Forum Discussion
Calculate the sum of multiple columns and rows
I I have 2 calculated Columns 1) Tuition Amount and 2) Travel Expenses that are validated for currency. I have created a calculated column:
=[Tuition Amount]+[Travel Expenses]
The problem is, it only shows the sum for each individual row. What I need is the sum of all rows displayed combined sum
2 Replies
- I usually do a workaround and build a Power Automate flow that runs every time the list item is changed. Make sure it only triggers if changes has been applied to "Tuition" and "Travel" (to ensure the flow won't run endlessly).
Change the "Total column" to a regular "number" field instead of calculated. Do the calculation of "Tuition" + "Travel" in the flow and update the Total on the item with that field.
Finally remove the field "Total" from the forms, so no one would update it directly. If its a worry I usually create an alert, if someone where to change this field. FrederickHargro2 there is no way to display that sum. Unfortunately it has never been possible with SharePoint. You would need to build a flow in Power Automate and then add the result of the calculation into, probably, a separate list. Or you could build an app in Power Apps to display that, but with SharePoint on its own it's not going to happen.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
