PowerTable has a built-in formula engine that can perform calculations on your data. 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.
1
To insert formula columns, go to Setup > Columns.
Setup > Columns
2
Select Add Visual Column > Add Formula Column.
Add Formula Column
You can also insert a formula column as shown below:
3
Configure the formula column by entering the column name and required formula, then click Save.
Configuring a formula column
You can create a formula column directly in the database by selecting the checkbox labeled "Create a database column."
Select the appropriate data type for the column. The formula column will be added to the source database.
Creating a formula column in the database
The formula column has now been added successfully.
Formula column added
Formula columns cannot be edited directly because their values are based on an underlying formula.
For more information about formulas and functions, you can refer to this section.