Add Formula Column
Last updated
Last updated
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.
To insert formula columns, go to Setup > Columns.
Select Add Visual Column > Add Formula Column.
Configure the formula column by entering the column name and required formula, then click Save.
The formula column has now been added successfully.
Formula columns cannot be edited directly because their values are based on an underlying formula.
To know more about formulas and functions, you can refer to