Why does Numeric Aggregator show "Invalid number" even though all values are numeric?

How To
, ,
1

Hi everyone,

I’m trying to sum up a numeric column (“Amount (C)”) from a Google Sheet using Make.com. Here’s what I did:

  1. Google Sheets → Search Rows module loads data correctly.
  2. I filtered rows by type using a Router (e.g., income vs. expense).
  3. For each route:
  • I used Array Aggregator to group the rows.
  • Then used Numeric Aggregator (SUM) to sum up the “Amount (C)” field.

The values clearly look numeric (e.g., 50000, 30000, 1, 5, etc.), and I removed any comma formatting in Google Sheets beforehand.

But I’m getting this error:

BundleValidationError
Invalid number in parameter ‘value’

Things I’ve tried:

  • Confirmed there’s no comma or currency symbol in the values.
  • Checked that the “Amount (C)” field is displayed with a 123 icon (numeric) when hovered in Make.
  • Tried referencing the field like this:
    {{25.Array[].22.Amount (C)}}
  • Also tried passing values through a Set Variable with parseNumber() – no success.
  • Even tried wrapping the array as JSON and parsing it again to isolate numbers.

Goal:
I just want to SUM the numeric column after aggregation, without using an Iterator if possible.
What am I missing? Why does Make think the numbers are invalid?

Thanks in advance for any ideas!

2

Hey there,

can you share some screenshots of the current setup and the errors you are getting?

3

Make sure the data type of the text you are trying to sum up is a number