Set Variable Not Evaluating Expression - Stuck with item["Amount (USD)"] from Array Aggregator

Hi everyone,
I’m working on a business report automation in Make.com that pulls data from a Google Sheet, aggregates it using the Array Aggregator, and then uses Set Variable to calculate totals like this:
sum(map(8; item; number(replace(replace(item[“Amount (USD)”]; “$”; “”); “,”; “”))))

But Make is not evaluating the formula, it just stores the whole expression as a long string, not the computed number.

I’ve tried:

Is there a trick to referencing fields from an Array Aggregator inside an expression in Set Variable?

Any help would be really appreciated :folded_hands:

Hey @Olaide_Bello , there’s always a way around it.

Since we’re dealing with arrays here, you can use either the map or get inline function.
There’s a bunch of other inline array functions. It depends on what you want to do.

Could you share the output data from the Google sheet search rows?

Thank you.

Your goal is to get a sum of the numbers, right?

If your goal is to sum up the numbers, this is what your scenario should look like.

Yes, I need to Sum up the numbers. I will be adding the Iterator module.
Thank you very much.

Hello @Olaide_Bello , Did it work?

No it didnt @Greatness_me

The last module is a numeric aggregator. Did you use a numeric aggregator as the last module?

Yes, I used a numeric aggregator