Forum Discussion
Solved
SP List Display Sum of Calculated Column
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...
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)
Bharath Arja - doesn't this method create an infinite loop?
I've actually stumbled across this problem myself and my thought process was to just copy the value from the calculation column and move it to another column, but that sounds super clunky because you'd now have two columns with calculated totals. Ironically, I found another blog post that pretty much addresses all of this and user Bojan Lazarevic pointed out this creates an infinite loop but one option is to change the trigger to only When new item is created. I guess my thinking of adding an extra logic check is not viable, or simply over engineering/over complicating: https://learn.microsoft.com/en-us/answers/questions/89029/total-of-a-calculated-column-on-sharepoint-365-and