Column dependencies:

Javascript formulas

This example sets up dependencies between grid columns by using formulas option.

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

Result of these formulas are treated as normal data by the grid and so they work seamlessly with sorting, filtering, grouping, treegrid, etc.

In this example:

• Total is dependent upon Domestic & Exports
• Profits is dependent upon Total ( result of 1st formula ) & Expenditure.

Note:

Similar use case can also be solved by using either Excel formulas or rowTemplate, two other very powerful features of ParamQuery grid.