SMART datagrid v.1 > Examples

[ grids ver.1.3.0]   Back  Forward

Calculated Columns Range  Example

Calculated Column set through cached can store and reuse the calculated values whenever necessary to improve performance. At this point, if expand the calculation area to the grid or row group level, it can display the values of a particular purpose in the calculated column cell. 

In the example below, it has appropriately combined calcBounds and calcRange of Calculated Column to calculate and display the total and inverse total of "Unit Price" and "Quantity" columns. If scroll the vertical scroll bar, you can check the cumulative progress. 

Grid - 1
rows

If set CalculatedColumn.calcBounds as GROUP, it will calculate the total of the row group level. You can do row grouping by "Country" column and check "Total Unit" column. 

View Source JSP 

See Also
CalculatedColumn.calcBounds
CalculatedColumn.calcRange
CalculatedColumn.valueExpression
CalculatedColumn.valueCallback
ValueColumn.summaryCallback
GridColumn.grid
DataSet
Examples
Calculated Column
Row Summary
Derived Fields