Can´t sum list of currency values

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

Many many thanks!

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.

1 Like

That worked!

Thanks a lot!

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.