Formula data type

[cluciani]

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.

[olgatrykush]

Hey @cluciani,

@frederikdc

The reason you get the error is because linked fields and lookup fields in Baserow are always considered to be lists, even if they only contain one item.

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

@cluciani

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

I’ll check this with the team.

[olgatrykush]

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