Formula data type

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What are the exact steps to reproduce this issue?

Dear Baserow Developers,

I’m experiencing an issue where the rollup field isn’t summing values from a formula field in a linked table, treating the formula field as an array instead of a list of numbers. For example, in my Recipes table, I have a rollup field to sum the “Ingredient Cost” formula field from linked RecipeIngredients records, but it fails, showing an error about expecting a list of numbers.

I tested this by copying the formula field’s value to a regular number field, and the rollup worked fine, confirming that the issue is with formula fields. This suggests a bug in how rollup fields handle formula fields, likely in the evaluation or type checking.

Additionally, when trying to summarize any formula field, the options are only “None”, whereas for number fields, they have “Sum”, “Average”, etc., which reinforces that there’s an issue with how formula fields are handled in aggregation contexts. I can share screenshots of this for every formula field, and it’s very easy to

Attach screenshots, videos, or logs that demonstrate the issue.


Hey @cluciani,

Would this solution also work for your case? Rollup Field Doesn't Work - #2 by frederikdc

I’ll check this with the team. :slightly_smiling_face:

Hey @cluciani, quick update on the footer aggregations for formula fields referencing other fields: we will add compatible footer aggregations. :slightly_smiling_face: