Sum a flexcel column

FLX TMS FlexCel for VCL & FMX
1

What's the best way of summing a column in a flexcel report?

Thanks


2

Normally the simplest is to add an "=Sum(b1:b2)" where you want the sum to be. Note that the sum has to sum at least 2 columns for the report to expand. Look st the third reports demo ("Database Reports") for an example, at cell H21 in the template.


There is also more information on this in "FlexCelReportsDesign.pdf", "Deleting Rows" section.

btw, if you want to have totals and subtotals in the same column, you can use the "=Subtotal()" excel function instead of "=sum".