To use Formula/Computation option in the Datatable,
- Inside the Datatable, click the ‘+’ symbol located in the right corner of the column name row.
- Select the Formula/Computation option.
- In the popup window, enter the column name and choose the data type you want to work with.
- If you select “Number” for computation, enter the formula in the text box under the Formula section.
- You can either map existing columns in the Datatable or manually input data to achieve the desired results.
- Click the “Save” button.
- If you choose “Date” or “Date & Time,” select the operation you wish to perform: “Add,” “Subtract,” “Between,” or “Duration.”
- For “Add” and “Subtract,” provide inputs such as the number of days, weeks, months, or years to add or subtract from the date.
- Inputs like “Number” and “Date” can either be mapped to Datatable fields or entered as constant values.
- For “Between” and “Duration,” choose the type and specify the two date & time values.
- If you select “String,” you can choose as many Datatable fields as you want to concatenate.
- If an incorrect formula is entered, an error message will be displayed.
