+8
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.
Best answer by kapilkjoshi
View original
+11
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.
+11
Reference to similar question.
perform math operation on collection
Were you able to resolve the issue?
+8
Hi Kapil,
Thank you for your response. I was able to resolve this.
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 ?
+1
Hi Sunil
I have a similar situation. Were you able to resolve your issue?
Thanks Ren
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.