Sum a column in a filtered table?

  • Resolved suburbanexile

    (@suburbanexile)


    2 years, 4 months ago

    Greetings and thank you for this amazing plugin. I’m trying to figure out if it will work for my needs. I love the look of the tables and appreciate all of the possibilities for sorting, hiding, etc.

    My use case would require quite a few small tables so I was trying to decide if manually updating dozens of tables would be sustainable. I was so excited to find the Premium plugin that allows filtering! And the filtering function works great — except it breaks the “Sum” function in my total column.

    I can get the sum function to work without filtering or get filtering to work without sums. Is it possible to make both work at the same time?

    I’m sorry I can’t provide a link. The page in on a staging copy that I have behind an administrative password.

    When I remove the filter, the column sums as expected. When I put a filter on the table, I get an !ERROR! Circle Reference message.

Viewing 1 replies (of 1 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    I see what you mean, but unfortunately, can’t think of a solution right now.
    Essentially, the problem here is that the formula parser that’s currently used in TablePress only supports fixed/static cell references. Thus, when rows are removed by the filtering, the reference points to cell itself.
    One thing that you could check: Move the cell with SUM to a different column. After that, you should not get the Circle Reference error anymore – but probably a “Cell does not exist” error…

    Something like this should be possible with TablePress 2.0 that is scheduled for release later this summer – it will ship with a much better and more flexible formula parser, where the references can be calculated on the fly.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Sum a column in a filtered table?’ is closed to new replies.