SUM_BY_KEY not working for me

Hi there

I am using firebase as a db and have troubles with SUM_BY_KEY.

That’s the schema I am using:

I tried:

Any help is appreciated.

Thanks
Andreas

Your schema isnt set fully

@Andreas I’m not sure if the SUM_BY_KEY formula will recognize subfields in the second parameter, that’s why the formula editor is complaining. Try SUM(MAP(data.Travels1, item.fields.price.doubleValue)) to first transform the list into a list of just the price values, and then sum the thing.

1 Like

@Mari Thanks Mari, the formula editor is still unhappy (list items are incompatible) but if I force it, it works