Can you explain how the wpDataTables ( ADD A FORMULA COLUMN )  can be used to generate a cumulative column against another column in the table, also is it possible to reset the cumulative on change of value of another column, e.g. you might want a running total of payments for each month, so rest for change of month

I have looked at the documentation and the math formula do not seem to support a running total but you support team suggested that it was possible, any help much appreciated

many thanks

Colin 

Hi Bogdan

I have several MySQL queries to generate income payments from share dividends and I need a cumulative column e.g.

Monthly Income Payments

month, payment, cumulative

Jan £2,100, £2,100

Feb £3,400, £5,500

Mar £1,600, £7,100 etc.

Also I may have the breakdown payments for each month and I want to reset the cumulative where there is a change of month

e.g.

Monthly Income Payments by Share 

share, month, payment, cumulativeByMonth

GSK, Jan, £240, £240

AZN, Jan, £300, £540

BAE, Jan, £250, £790

AAL, Feb, £400, £400 => cumulative reset as change of month

GNK, Feb, £300, £700

MKS, Feb, £200, £900

TSCO, Mar, £275, £275 => reset as change of month etc.

Note sum(payment) where payment is a numeric column on my query results in an error message, perhaps I have the syntax wrong

Unable to calculate, error message: No Equation given

Many Thanks

Colin

Hi Bogdan

The cumulative column would be the formula type column, so I would be using a formula to evaluate the running total of payments for each payment.

I am not sure how to construct a formula to support a cumulative or running total on a column (in this case payment)

Best regards

Colin

Hi Bogdan

Thanks for the explanation, I will have to perform the cumulative operation within the SQL query instead of using the formula column

Best Regards

Colin