SUM_BY_KEY not working for me

Andreas_Niedermann · January 23, 2022, 8:31am

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

JOHN_WORSHAM · January 23, 2022, 10:07am

Your schema isnt set fully

Mari · January 24, 2022, 9:36am

@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.

Andreas_Niedermann · January 24, 2022, 9:45am

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