Okay
  Public Ticket #2910849
formula columns
Closed

Comments

  • Mauricio Ramces Carmona Garcia started the conversation
    November 6, 2021 at 9:26pm

    i use a formula column, but i can´t totalize this column, how i can do it

  • [deleted] replied
    November 9, 2021 at 4:50pm

    Hi Mauricio

    Thank you for reaching out to us.

    There are several limitations when using formula columns in wpDataTables:

    1. One formula column cannot be used in another. This limitation can be avoided by using nested calculations.
    2. In tables with server-side processing formula, columns cannot be used for grouping, filtering, and sorting. Basically, formulas are calculated only for the rows that are immediately visible; Therefore, it’s not possible to “know” the values for currently invisible rows. Please note that this also applies to the “Manual” tables, as they also use server-side processing by default. Also, of course, it is not possible to edit the cells generated by formulas in the editable tables.
    3. Adding a sum in the sum row for formula columns is not yet supported.
    4. Using calculation functions in formula columns is not possible