Hi,
I am building an application that requires rollup to perform Sum on computed columns but the Glide Big table is not supporting it yet , Is there any alternate way to perform rollup-like functionality with Glide Big tables?
My app requires more than 25k Rows but without rollup how can I build sum for specific requirements?
You can use one or more joined list columns to fetch the non-computed values required to calculate the sum, and then pass those to a JavaScript column. This will work well for smaller subsets of data from a GBT, but if you need to sum over an entire table then you are better off pre-calculating the values and saving in non-computed columns.
This is unfortunate, because usually in SQL you can call for the sum of a column for the whole table. With this limitation, things can get truly challenging for applications where you need the total of a column where the related dataset extends with over 100 rows. @Darren_Murphy did you face this challenge before?
Hi All – I’m having the same problem with not being able to SUM a Big Table column via a Relation. I tried to create a joined list of values and use JS to do math on it, but seems like a Joined List isn’t possible with Big Tables either.
Anyone know the best way nowadays to do SUM of values on a Big Table?
My use case is that I’m trying to sum up the prices of parts associated to an invoice. The parts are in a GBT and the invoice is in a GT.
Thanks!