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 Mak…

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

Olaide_Bello July 3, 2025, 10:55am 10

Yes, I used a numeric aggregator

Topic		Replies	Views
Getting the sum of items of an array but first using parseNumber to convert string to int Getting Started arrays , google-sheets	3	41	June 19, 2025
Issue Extracting Data from Array Aggregator in Make How To arrays	2	31	June 17, 2025
Need Help with Google Sheets Data Aggregation via Make.com How To google-sheets	4	1423	March 19, 2024
Invalid number in parameter Getting Started	8	2351	December 7, 2023
How to Map the JSON Data properly using Aggregator or Set Variables for update to Sheets? Getting Started mapping , arrays , google-sheets	3	72	April 12, 2025