When you use a column with a calculated value in a SharePoint
list, you cannot combine it with the Totals view.
The Totals view displays a calculated value (the average,
count, maximum, minimum, sum, standard deviation or variance)
for each column with numbers above these columns, so it
is very useful and you would really want to have Totals
for a calculated column that contains numbers also. Solve
the problem by letting a flow do the calculation and update
Unfortunately the Totals view can only be used in lists
with the classic interface when this is written, but it
will hopefully soon be added to modern lists too.
the demo below, Peter Kalmström, CEO and Systems Designer
of kalmstrom.com Business Solutions, shows how to create
a flow for calculation. The flow he creates, calculates
the sum of values in two currency columns in a newly created
or modified item a SharePoint list and updates a third currency
As Peter is using a currency column for the result of he
calculation – and not a calculated column – he can use the
Totals view without problems and see the Totals for the
Steps to create a flow that calculates sums from column
Create a Number or Currency column for the list
you want to use.
Create a flow from blank and select the trigger
'SharePoint – When an item is created or modified'.
When you have entered SharePoint site and list name,
add the action 'SharePoint - Update item' for the same
site and list.
Add the dynamic contents 'ID' and 'Title'.
Create an expression for the field that should be
calculated: add + the dynamic contents for the columns
that you want to include in the calculation. Separate
them with comma.