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:
- Typing the formula manually
- Mapping
Amount (USD)
from the right panel - Using different module numbers, variable lifetimes
- Confirmed that the Array Aggregator has actual data
Is there a trick to referencing fields from an Array Aggregator inside an expression in Set Variable
?
Any help would be really appreciated