Totals in Large List not Working

%3CLINGO-SUB%20id%3D%22lingo-sub-1512883%22%20slang%3D%22en-US%22%3ETotals%20in%20Large%20List%20not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1512883%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20currently%20have%20a%20Sharepoint%20O365%20List%20(modern%20view)%20of%207400%20items%20that%20stores%20our%20inventory.%20As%20we%20are%20over%20the%205000%20List%20View%20Threshold%2C%20we%20have%20made%204%20different%20views%20to%20limit%20the%20rows%20returned%20(5%20counting%20the%20All%20Items%20list%20which%20we%20don%E2%80%99t%20use).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20we%20are%20having%20is%20that%20when%20we%20set%20a%20Total%20Count%20for%20various%20columns%20-%20Sharepoint%20is%20not%20providing%20the%20proper%20number%20of%20rows.%3C%2FP%3E%3CP%3EView%201%20(default%20view)%20%E2%80%93%20provides%20the%20proper%20count%20%E2%80%93%204084%3C%2FP%3E%3CP%3EView%202%20%E2%80%93%20Total%20Count%20shown%20is%20916%26nbsp%3B%20but%20it%20should%20be%202630%3C%2FP%3E%3CP%3EView%203%20%E2%80%93%20Total%20Count%20shown%20is%201922%20but%20it%20should%20be%203113%3C%2FP%3E%3CP%3EView%204%20%E2%80%93%20Total%20Count%20shown%20is%203077%20but%20it%20should%20be%204287%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20Views%20are%20configured%20exactly%20the%20same.%20I%20had%20tried%20changing%20the%20default%20list%20to%20see%20if%20it%20would%20make%20a%20difference%20but%20it%20did%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20The%20Total%20Count%20issue%20we%20are%20experiencing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1512883%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521534%22%20slang%3D%22en-US%22%3ERe%3A%20Totals%20in%20Large%20List%20not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521534%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F261018%22%20target%3D%22_blank%22%3E%40cbushca%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20column%20types%20are%20you%20totalling%20up%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533586%22%20slang%3D%22en-US%22%3ERe%3A%20Totals%20in%20Large%20List%20not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533586%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11625%22%20target%3D%22_blank%22%3E%40Steven%20Andrews%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20doing%20a%20count%20on%20a%20Choice%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

We currently have a Sharepoint O365 List (modern view) of 7400 items that stores our inventory. As we are over the 5000 List View Threshold, we have made 4 different views to limit the rows returned (5 counting the All Items list which we don’t use).

 

The issue we are having is that when we set a Total Count for various columns - Sharepoint is not providing the proper number of rows.

View 1 (default view) – provides the proper count – 4084

View 2 – Total Count shown is 916  but it should be 2630

View 3 – Total Count shown is 1922 but it should be 3113

View 4 – Total Count shown is 3077 but it should be 4287

 

All Views are configured exactly the same. I had tried changing the default list to see if it would make a difference but it did not.

 

Any ideas on The Total Count issue we are experiencing?

2 Replies
Highlighted

@cbushca 

What column types are you totalling up?

Highlighted

@Steven Andrews 

We are doing a count on a Choice column.