Autosum Filtered Table

  • Resolved jamesbrinsley

    (@jamesbrinsley)


    8 years, 9 months ago

    Hi,

    I have a table with 3 columns; Name, Team, and Points. I have managed to use =SUM(C2:C[table-info id=2 field="number_rows" /]) to calculate the sum of everyones points. I have created a separate table for each team by applying ‘Filter’ to the shortcode. However, I cannot get the total figure to update in the filtered tables. I am getting the error: !ERROR! Circle Reference.

    I have found a previous support request, LINK but I can’t seem to get that to work either.

    Would you be able to offer any assistance?

    All the best,

    James

    https://www.ads-software.com/plugins/tablepress/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Unfortunately, formulas and filtering don’t always play well, as the filtering alters the row/column numbering ??
    To investigate this, I’d need more information about the structure of the tables, and the used Shortcodes for the filtering.

    Regards,
    Tobias

    Thread Starter jamesbrinsley

    (@jamesbrinsley)

    Hi Tobias,

    Thank you for getting back to me.

    I have taken some screenshots for you, they can be found here.

    The website can be found here.

    Hope this helps.

    James

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi James,

    thanks for the screenshots! The problem basically is that your formula contains itself again. For example, in your screenshot,

    [table-info id=2 field="number_rows" /]

    will return 7, thus the formula is

    =SUM(D2:D7)

    Now, that formula is actually in cell D7, so in order to calculate the value, we would already need the value – which is an infinite loop, or circle reference.

    Unfortunately, I don’t really see a good workaround for this. Part of the problem also is that the [table-info] Shortcode will always return the number of rows in the full table, as it can not take the filtering into account ??

    Regards,
    Tobias

    Thread Starter jamesbrinsley

    (@jamesbrinsley)

    Hi Tobias,

    I see what you mean.

    How does the table information displayed underneath the table work? I have activated it now so that it should be visible on the Leaderboards page.

    Is there any way i can just return that figure in the cell?

    Thanks,

    James

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    sorry, that table information will not help either ?? It only shows the number of visible, JS-filtered, and available rows. It’s completely done in JS and does not have a possibility to add actual table content ??

    Regards,
    Tobias

    Thread Starter jamesbrinsley

    (@jamesbrinsley)

    Hi Tobias,

    Thank you very much for your help.

    I think I will have to export the table and manually create the total figures.

    All the best,

    James

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi James,

    yes, that might be the best. Formulas that need variable cell references don’t really work that well yet :-/

    Regards,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Autosum Filtered Table’ is closed to new replies.