Well I was able to figure it out. In Sharepoint the functions were only calculating based on the items that were in the default view. So we had 2 pages of items yet only 100 items on the first 'default' page. I was able to figure this out when I decided to do a count function instead and ran into the same issue. So I was able to change the ...