Numeric Aggregator Isn't summing values, instead it's concatenating

I am trying to sum add a variable from a number field in clickup up with the value 1 everytime a status changes. It is pretty much working as expected except for the summing of the values. I’ve tried putting in two numeric values myself and it works fine, however, when I introduce that variable value, it concantenates with with number 1 instead of adding. i’ve checked and the custom field from clickup is coming in as a number type (see image). I’ve also attached an image of teh formula I’m using. Would appreciate any help on this, thank you in advance.

Hi @Jonathan_Adeleye,

that’s really weird, because the type is indicated as number.
I’d still give it a shot with parseNumber() around the custom field, maybe that solves it?

So I managed to get it working but I’m not 100% sure why it works now. Here’s the workflow, it only had one numeric aggregator before but when I added in a second one that’s what fixed it.

Also sending on what is on the first and second numeric aggregator

Hi @Jonathan_Adeleye,

thanks for sharing what has worked for you!
Looking at the scenario, I don’t think you need the aggregator at all but if it works, don’t change it unnecessarily :smiley:

Best,
Richard