Sum the values of specific entries

Hi there,

when I fetch the warehouse stock quantities from my erp system, I get some multiple bundles for same article number. The reason is, that my erp system is tracking them on a individual batch-id size, as they are cosmetics.

that means, I can get for the same product e.g. 3 bundles with different stock quantities which I then should sum to a single bundle with the combined quantity of the 3 bundles.

I am now trying that for a while, but can’t get any solution.

How could this be done?

thx

Hi @Dusticelli,

as always, there are multiple ways of doing this :slight_smile:
You might sum them up in Google Sheets. Search rows for ID, then take the previous value + the value from this operation.
Outside of GS and in Make you can use the Array Aggregator to aggregate multiple collections into one array. Then take the sum of this array.

It is highly dependent on your workflow which solution I would choose… :slight_smile:
Hope it helps!

Best,
Richard

2 Likes

Hello Richard,

thanks for your help. Inside GS I could sum them, but this would cause problems at other places. So I think

in Make you can use the Array Aggregator to aggregate multiple collections into one array. Then take the sum of this array.

that would be my solution. I tried a while with exact that module, but I think I don’t know how to use that.

When I use the array aggregator I don’t have the “value” option like it is explained in the help section from make.com and the 2 options I can choose doesn’t work.

I think I would need to tell the aggregator to take only those bundles that have same value within a key, and then, how can I tell the aggregator to use in that case another value from another key to sum together?

Can you help me a bit further with that?

thx