cvuppala
Apprentice

Add column values using Collection

Jump to solution

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.

0 Kudos
Reply
5 Replies
kapilkjoshi
Apprentice

Re: Add column values using Collection

Jump to solution

Hi

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.

Reply
kapilkjoshi
Apprentice

Re: Add column values using Collection

Jump to solution

Reference to similar question. 

perform math operation on collection 

Were you able to resolve the issue?

0 Kudos
Reply
cvuppala
Apprentice

Re: Add column values using Collection

Jump to solution

Hi Kapil,

Thank you for your response. I was able to resolve this.

0 Kudos
Reply
Sunil_Khuttan
Novice

Re: Add column values using Collection

Jump to solution

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 ?

0 Kudos
Reply
Ren
Scholar

Re: Add column values using Collection

Jump to solution

Hi Sunil

 

I have a similar situation. Were you able to resolve your issue?

 

Thanks Ren

0 Kudos
Reply