Forum Discussion
Anonymous
Feb 10, 2023Sharepoint lists - Calculate query
Hello, First time posting. I'm quite a novice to this stuff. So apologize up front if this is a very simple question. In SharePoint list I am trying to create a simple inventory system. I need to...
RobElliott
Feb 11, 2023Silver Contributor
Unlike Excel a calculated column can't loop through all the items with a particular ID and give you a total, it only works on the current item. You could create views of the list, 1 for each ID and turn on Totals in the list settings.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)