Skip to main content
Nintex Community Menu Bar
Solved

Calculate sum of numbers in a collection

  • August 2, 2023
  • 5 replies
  • 271 views
  • Translate

Forum|alt.badge.img+2

I have a collection that holds multiple numbers derived from list items. There are more than two numbers in this collection at any one time. I need to add those numbers together and was told I can do so with a math operation, but I haven’t been able to figure it out. 

This is in SharePoint 2016.

Best answer by bamaeric

Below are images for an online of how you would total the weekly hours for each employee. Please let me know if you have any questions.

 

 

View original
Did this topic help you find an answer to your question?

5 replies

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 464 replies
  • August 2, 2023

Forum|alt.badge.img+2
  • Author
  • 9 replies
  • August 3, 2023
bamaeric wrote:

So I reviewed those posts and I’m still stuck. Here is what I am working with:

This is the section of the workflow I am working on. The goal is to get each employees time entries for the given week, add the submitted time together, and store that total in a new list item on a different list. It successfully queries the list for each entry based on employee, but I am completely lost on how to get the sum of entered time.

To simplify: For each employee, get their time entries, add together all of the weekly regular hours entered, and update a corresponding list item in a different list with the full total. 

For each:

 

This is the list query to get their entries:

 

 

This is the math operation where I am stuck. The numbers I need to add together are all in a collection variable. Do I need to turn the collection into something else before this?
 


And this is the update item, which does work correctly when I tested the math operation using basic values. 

 

 

 

Translate

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 464 replies
  • Answer
  • August 3, 2023

Below are images for an online of how you would total the weekly hours for each employee. Please let me know if you have any questions.

 

 

Translate

Forum|alt.badge.img+2
  • Author
  • 9 replies
  • August 3, 2023

It worked! Thank you so much!

Translate

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 464 replies
  • August 3, 2023

You’re welcome. Glad I could help!

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings