Feb 27 2023 04:47 AM
Hi
I would like to sum a number column using a method that I can then use that sum with another column sum and subtract one from the other. I have used the built in method but cant access the value to do a calculation on.
Thanks for any help.
Feb 27 2023 09:05 AM
SolutionFeb 27 2023 09:36 AM - edited Feb 27 2023 09:44 AM
@Faldo you can't do calculations based on the sum of different columns. Apart from using a calculate column on each item as suggested by @Jennifer_Wilson which is the solution I would use, the only other method is to build a flow in Power Automate to loop through all the items, add the number of each one to a variable then update another column with the overall result of that variable.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Feb 28 2023 01:44 PM
Thanks for replies.
Not quite sure im getting it right. Im trying to sum up a complete column say credits and a column debits and subtract debits from credits to get a balance.
Feb 28 2023 11:15 PM
@Faldo yes we know, but with SharePoint you can't do that which is why there need to be workarounds.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Mar 01 2023 02:03 AM