Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
SaaS
What do you need help with?
Hi,
I am new to BR, coming from Airtable. In Airtable, it is possible to summarize a field/column even when the data is generated by a formula. As seen in the attached screenshot, I have a Total Price column that is a formula of the actual price X a specific modifier. The result is formatted as currency but BR doesn’t recognize it as such. At the very bottom where you can summarize fields/columns, only “none” appears.
The initial “price” field is a lookup field in case that impacts the functionality.
Please attach screenshots or videos if they help illustrate your question.
hi @farmermaker, can you share a screenshot of what you’re experiencing because if I create a formula field that uses a number field with a prefix and decimal places - the formula field summary keeps that formatting.
Thanks for the video @farmermaker, very clear now and you’re absolutley right that the lookup is what is causing this issue as it is essentially changing the “number” field in to an array because of the link associated with another table.
If your Price field in your Crop table is only linking a single price value, you could use a Rollup field instead of the Lookup, using a min,max or sum function for the rollup. This would maintain the itnegrity of the number of the value and you could then use this rollup field in your formulas isntead of the lookup that you are currently using.
