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,...
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.
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.