Sum of calculated column

  • Resolved souriceau44

    (@souriceau44)


    5 years ago

    Hello

    I created a calculated column: quantity * unit price. (col_id = 176)
    qtyv7 * upricev7

    I want to add up this calculated column.
    [wpdatatable_sum table_id = 58 col_id = 176]

    I inserted this short code in the page
    But the result gives me 0
    Sum: 0.00

    Weird: when I refresh the web page, the correct sum appears (sum: 177,020) but disappears immediately when the table is displayed.

    thank you in advance and have a good day
    Jo

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    Hello again.

    If understood correctly, you created a Formula column, and you want to add the SUM calculation function below that column?

    If that is true, we’re sorry to disappoint you, but like our official documentation about this states – you cannot use calculation functions on Calculated (Formula) columns.

    Kind regards.

    Thread Starter souriceau44

    (@souriceau44)

    Thank you for your answer,

    I inserted this [wpdatatable_sum table_id = 58 col_id = 175] in another page and it works.

    Have a good day

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Sum of calculated column’ is closed to new replies.