Can´t sum list of currency values

1

Im driving a bit mad with what seems to be super super simple.

I have a formulaMap that returns a list of currency values (as stated by the formula helper or preview).

I want to sum all this values, but I simply can´t :person_shrugging:
I even tried turning each value into a number with ToNumber(), but still won´t work.

Can someone help me please? Link to the doc is here, and the link to the formula row is here

image
image1052×1139 67.2 KB

Many many thanks!

2

Hey Joaquin,

I didn’t dig deep to find out why, but in the list of currency amounts you had an error. I just added a filter at the end ‘.filter(currentValue.isnumber()).sum()’, which gets rid of that error item in the list and then sums the quantity.

3

That worked!

Thanks a lot!

For the records, I found the error item, but it would have been impossible without this temp solution