0

Is this possible where I have two lists - one is a claim form and the other is an authorisation amount. The results in the authorisation amount will contain a unique reference with a total amount that has been approved whilst the claim one will be individual claims with the refence number attached (links to the authorisation list)

What I want to do is create a third list with the unique reference (auth list) - authorisation value (auth list) - sum of all Claims (linked by unique reference - claim list)

Is that possible? if so, any ideas easiest way of doing it? I've been searching for sumifs in sharepoint but I'm a novice so any plain English guides will be much appreciated.

Thanks

|improve this question
1

I just did something similar recently with a Polling mechanism.

Basically I have 2 lists, Polls and Poll Votes. What we wanted was a way to show the total number of votes for each option without exposing who voted for what exactly.

What I did was setup 2 workflows and a third list. The first workflow creates a "PollCounter" item in the third list. This tracks the individual counts for each vote option. Then whenever someone submits a vote, the second workflow runs and increments the count for the respective vote in that third list.

It involves a lot of lookup references and conditional checks, but overall it works well. Just be careful with how that third list is secured. Restrict access so that only admins or the workflow can manipulate the values in it. I would verify this under load as well, if 100 people submit a vote at the same time, the count might get skewed. In your case I'm not sure how frequently it's updated.

Another much simpler option might just be setting up a profile page with filtered "lookup" views. Using views you can create a sum of all items in a column, and that view can have a filter applied based on the "current" item whose profile you're viewing. Would that work in your case?

|improve this answer
  • Sounds positive however being a novice I'd probably struggle to get the workflow route working. The lookup views may work - any idea/guides to do that? I was able to get a sum of all values using a create view on the claim submissions but it's the lookup bit that I'm not sure how to do. – Mesh1o Aug 3 '17 at 20:23
  • 1
    Simplest way I know is to open the DispForm.aspx for the "master" record (ie. the category list item). On that page open it in edit mode and add a list view webpart for the "child" list that contains the records with the amounts you want to sum. Then, set that list view to be filtered by the parent webpart (ie. the category item). Hope that helps... – Chad Aug 12 '17 at 14:46
  • so I'm still trying to get this to work I came across this - codeproject.com/articles/687644/webcontrols?pageflow=fixedwidth - but not sure if this would work? any other ideas on how I could achieve this? – Mesh1o Aug 24 '17 at 21:58
  • 1
    That looks about right. It's essentially the same thing I suggested in my first solution. Basically whenever something is created it increments the running total in a separate list. Still, you can probably just create a view, group by the unique key, and add a SUM to the value column. – Chad Aug 30 '17 at 20:43
  • thanks Chad - but if I create a view from it can I use that data in another library/list? I didn't think it was possible to pull information from summed views? – Mesh1o Sep 6 '17 at 6:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.