Page Comparison

...

You can input formula inside embedded JavaScript Editor and get results on the grid view. The grid can process formula logic and display formula results in a separate column.

Configuration

Input formula inside embedded JavaScript Ace Editor and get results on the grid.

...

1. Add a new column to the grid, using formula column type 
   

   Image Modified

2. Input column's details:
   
   Column type - select Formula type.
   Identifier - a unique variable to identify the column. Required field - you can set the desired value here.
   Title - column title, displayed in the grid. 
   Column IDs - list of existing columns' IDs. Use in order to create a formula.
   Formula expression - embedded JavaScript editor, where you need to input your formula. Uses Ace Editor, which highlights the syntax. 
   Summary Label - label name, that will be used in the column summary.
   Aggregation operation -  select aggregation operation of the column data: sum, average, min/max or custom formula.
    

3. Input the formula, based on the grid columns' IDs.

   Warning
   title Attention
   Use column IDs in the formula expression. Code Block language js theme Eclipse title Formula code example if($(calculate)){ return $(salary) + $(bonus) } else { return $(salary) }

   
   

4. Save changes.
   
   

...