Forum Discussion
Sum for a Calculated Column
I am tracking invoices for projects throughout the year. The columns in my SharePoint list include: PROJECT TITLE JAN, FEB, MAR… DEC (monthly invoice amounts, formatted as currency) ...
With SharePoint on its own this isn't possible, but there is a workaround using Power Automate that will put the sum from the monthly total columns (i.e the sum of the total column) in a new column on the item with the maximum ID. It doesn't require you to loop through all the items so it drastically reduces the number of api calls if you have a large list.
Let me know if you want details of the flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)