Calculation Error

  • Resolved ceslogon

    (@ceslogon)


    5 years, 2 months ago

    Hi all, I tried to use SUM function in the table, it worked partitially. My aim is to sum all the values in a column so I use =Sum: {SUM(B2:B8)} function, and it worked. But I would like to sum as new raws added. Otherwise it gives error the cell does not exist. This function can be used if B8 is already exist but I would like to define B100 which is not exist. Otherwise every time I want to add new raw, I have to update the function.
    When I tried to run function=Sum: {SUM(B2:B100)} where as there are only 8 raws, it gives there is no cell for B9. I also tried =Sum: {SUM(B:B)} did not work either. Is there a way to define this function? Thank you in advance

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    5 years, 2 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    I see what you mean, but unfortunately, I don’t have a solution for this at the moment 🙁 The formula engine does not allow for such full-column operations yet. I’ll however gladly take this suggestion and will try to find a solution for a future version!

    Best wishes,
    Tobias

    Thread Starter ceslogon

    (@ceslogon)

    5 years, 2 months ago

    Hi Tobias,
    Thank you for your reply. I created a workaround for it. I added 100 emtpy raws solved it. But this is only a workaround because there are 95 empty lines in the table.
    Best wishes
    Aşkın

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    5 years, 2 months ago

    Hi,

    nice, good idea! You could maybe try hiding the empty cells with some CSS code. For example, add this to the “Custom CSS” textarea on the “Plugin Options” screen of TablePress:

    .tablepress-id-123 td:empty {
  display: none;
}

    123 is the table ID here.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Calculation Error’ is closed to new replies.