Javascript formulas

This example shows support for formulas in the grid columns by using formulas option.

These are used when values in a column are dependent upon corresponding values in other one or more columns.

Result of these formulas are considered as normal data of the grid and so they are fully supported while sorting, filtering, grouping, treegrid, etc.

Array data is used here, though JSON data is more commonly used.

In this example,

Note:

These javascript based formulas should not be confused with Excel formulas, which fortunately are also supported by grid.