Page Comparison

...

1. Click Data Builder and collate data based on your requirement.
   NOTE: If you are changing an existing data aggregator that is already being used in reports, ensure that you re-configure the data aggregator in the respective reports to get the updated data columns.

2. Click child datasource in which you need to create a derived column.
   Columns of the selected datasource appear on the right-hand side of the page.
   

   Image RemovedImage Added

3. Click Derived Columns tab.
   

   Image RemovedImage Added

4. Provide name for the new column in Derived Column ID field.
   

   Image RemovedImage Added

5. Enter the formula for the column in Formula field. Here we subtract the two columns.
   NOTE:
   Subtraction – The – operator is used in derived column field in Data Builder.
   For example: CREDIT – DEBIT
   

   Image RemovedImage Added

6. Click Save.
   Once the derived column is saved, it gets displayed on the right side.

7. You can also delete the derived column by clicking the close icon.
   

   Image RemovedImage Added

8. Click Save to save the data aggregator.
   

   Image RemovedImage Added

   
   In the following sample report, TOTAL is the derived column that shows the result of the subtraction JEXL formula expression:
   

   Image Removed

   
   

   Image Added