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?
Solved! Go to Solution.
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.
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 ?