The formula column type is used to implement calculation based columns. Supported are arithmetical calculation (+, *, -, /). Please note that data in formula columns is not searchable. To create a formula, click Manage:
Syntax: Column names should be quoted. Also its important to check the column types of the columns used in the formula. “Calculable” column types are: number and decimal number. Use the validate-button to check if your formula is syntactically correct.