I would like to have a column B that would sum up 14 rows at a time from column A. so for example:
Column B should sum up rows 1-14, 15-28, 29-32, etc. from column A.
is this possible?
thanks
I think doing this in another table would make more sense, but can I know more about your use case?
My idea is having another table with an “index” column, starting from 0, then, 1, 2, etc.
In your current table, have a math column that’s also called index. You would use a formula like: FLOOR((A-1)/15) with A being the row index of each row, also starting from 0.
So for row 1 to 14 (index 0 to 13) you get 0, 15 to 28 (index 14 to 27) you get 1 and so on.
Create a relation based on those indexes, and a rollup to sum.
1 Like
The use case is I have a counter that increments by 1 for each logged in user (using row ID, query, and lookup to increment). Once the logged in user gets to 14 entries (each entry is a numbered value), I would like to do a roll up on those 14 entries. Then on their next 14 entries, I would like to do a roll up on those 14 entries and etc.
So for the formula you state below, is “A” the index from the other table or the current table? Can the index in the other table be referenced to my counter that’s already made?
A should be the index from the current table. You calculate that for the “grouping index”, and then go to the new table to create a relation based on that index.
Yes that worked. Thanks!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.