Formula columns are calculated columns created from your data that enable you to derive business-specific metrics or calculations on the go. You can add them at the visual level or directly to your source database (database column).
Common use cases for formula columns include calculating profit margins, tracking performance metrics, creating planning and forecasting calculations, generating status indicators, and building custom KPIs from existing data.
To insert formula columns, select PowerTable > Insert Column > Formula Column.
Enter the column name.
Enter the required formula in the formula box.
When you place the cursor in the editor, a context assistant appears automatically with Functions and References. Or press Ctrl + Space to open it.
As you type, the suggestions are automatically narrowed down.
Use the References tab to find and insert available columns from the current table into the formula.
Use the Functions tab to browse and insert supported functions, such as SUM, MIN, MAX, and AVERAGE, into the formula.
You can specify the currency type and the number of decimal points to display.
If you want to add the formula column directly to the database, check the Create a database column checkbox. Then, choose the appropriate data type and attributes such as length, precision, or scale for the column in the target database.
Please ensure you have the required permissions to the database you are connected to, as you are adding a column directly to the source database.
