Calculated Column Demo
Calculated columns are custom columns that you create (at design or run time) where the value is now in the bound dataset but is derived from other columns in the row.
Create them with an Expression which can range from straightforward to incredibly complex (we use Math.JS). They become a 'normal' column in the grid and will update automatically as other values change.
This example we created 2 Calculated Columns: 'Avg Item Cost' and 'Profit' (click on the 5th button in toolbar to see details of the Expression - or 'Edit Expression' in the Column Header menu). And because they are treated as 'normal' columns we were able to include them in the layout we created and also to style them using Conditional Styles.