Cannot rollup or sum Formula fields

Technical Help
1

When trying to create a Rollup field that sums values from a Formula field in a linked table, Baserow returns an error:

argument number 1 given to function sum was of type array but the only usable type for this argument is a list of number, or duration values obtained from a lookup.

Steps to reproduce:

  1. Create a Formula field in Table A that calculates a numeric value
  2. Create a Link to table field from Table B to Table A
  3. In Table B, try to create a Rollup field that sums the Formula field from Table A
    Error occurs

Expected behavior:
Rollup should be able to sum numeric Formula fields, just like it can sum Number fields and Lookup fields.

Impact:
Cannot aggregate calculated values across linked records, forcing workarounds like manual number fields or external calculations.

2

Could you please share the formula you’re using? If the formula returns a numeric value, it should work :thinking: