Forum Discussion
jonboylib
Jul 19, 2022Iron Contributor
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...
- Jul 19, 2022
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)
powerskirt
Jun 14, 2023Copper Contributor
Bharath Arja - doesn't this method create an infinite loop?
NathanPiahana
Aug 14, 2023Copper Contributor
Good point, I think it would (without trying) as the generation of the calculation would constitute an edit. I suppose to workaround this, you'd need to add another logic check, or create a variable, and run the actual sum part only when that criteria is met (i.e. when the edit is NOT the calculation itself) but that seems like over engineering to me.