Hi,
Here is my scenario:
I would like to Query list and return certain numbers into a collection variable and add all the numbers in the collection variable and store the resulting sum in a variable.
Is this possible? if so, how?
Please help.
Solved
Add column values using Collection
+8Best answer by kapilkjoshi
Once you have the collection from Query action, create a For Each loop. Create a variable called varSum of type number.
Inside loop (for each number in the collection), Add Math function. It would look like this:
Workflow variable varSum + num (from collection) , save in varSum.
When the loop finishes you will have the sum of all numbers. Hope that helps.
+11Once you have the collection from Query action, create a For Each loop. Create a variable called varSum of type number.
Inside loop (for each number in the collection), Add Math function. It would look like this:
Workflow variable varSum + num (from collection) , save in varSum.
When the loop finishes you will have the sum of all numbers. Hope that helps.
+11Reference to similar question.
perform math operation on collection
Were you able to resolve the issue?
Hi, I have a list with a category column. I need to add values of few column in the list as per category. I don't think using foreach is a good idea as there are 8 to 10 categories, Is there any way I can add all the items in a collections ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.