A custom column is a column that is computed from other columns using a formula. If you need more flexibility for adding new columns than the ones provided out of the box in Exportier, you can create your own custom column. This feature is available only for Professional and Unlimited plans.
Let's assume that you have a report with the following columns:
Using the Price and the Inventory item: Unit cost columns, you'd like to create a new column Profit calculated by subtracting the Inventory item: Unit cost column from the Price column.
The goal is to create a report with a new Profit column:
Add a custom column
To add a new custom column, click the Add custom column button at the top right corner of the COLUMNS section.
You will see a modal window where you define the column name and the formula to calculate a value. After specifying all the needed data, click on the Apply button.
You can find your custom column in the columns list.
How to edit or remove a custom column
To edit or remove a custom column, click the Edit or the Remove button, which appears after moving the cursor on the column item.
How to build a formula
Currently, we support several expressions in the formula:
Math expression allows you to specify calculations using other column references, individual numbers, or both. In math expression, you can use a reference to any regular column. Currently, we support several math operators in the math expression:
You can also use parentheses to order your operations in the math expression.
Using reference to a custom column is not allowed.
How to use: Place math expression in double square brackets.
In some cases, you will see the ERROR word or the NaN word in the custom column cell (in the report file). These are error types, and each of them has a specific meaning. ERROR means that your formula is invalid or contains a reference to the not selected/not existed column. NaN (Not a Number) means some issues with math calculations. One example is division by zero.