SOLVED

SP List Display Sum of Calculated Column

Contributor

Using SP Online and lists, I have two columns

 

 - net price (number column)

 - total price (calculated column)

 

The calculated column contains formulae that multiples [net price]*1.2

 

I now need to see the sum of both of these columns. I can achieve this for net price, but I can't see the option for total price when I go to list settings > edit view >totals

 

I assume this is because the total price column is a calculated column?

 

How can I achieve this without any programming and using default SP online functionality. 

2 Replies
best response confirmed by jonboylib (Contributor)
Solution

@jonboylib unfortunately you can't sum a calculated column. Somebody at Microsoft put that into the "too difficult" bin many years ago which was a rubbish decision.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

You can use Power Automate to perform the calculation and update a new field (number column) and use the new field for Total. You automation should run every time is updated or a new item is added.