/
Formula Fields

Formula Fields

A Formula field is a type of custom field, whose value is automatically computed by based on a formula or conditional logic. It enables users to define complex data manipulations and perform arithmetic, logical or conditional operations, which are all calculated at run-time.
Let us take an example:

Say your business practice is to take 10% of the project budget as an advance. Instead of manually computing it and changing it every time the budget changes, you would define a formula field that will compute it as 10% of the budget. To further complicate the scenario, let us assume that your policy is to take an advance of 10% for projects with budget up to $1000 and 15% above that. You can define such a formula and avoid chances of errors in manually computing this field. The formula would be

${me.budget <= 1000 ? me.budget * 0.10 : me.budget * 0.15}

For a project with a budget of $500, the advance amount will show $50 (10% of $500) while that for a budget of $5000 will show $750 (15% of $5000). If you change the policy, just change the formula and the new value will show up for all projects.

Except for the fact that you cannot enter a value for formula fields they are identical to the other custom fields. These fields can be viewed in tabular reports or charts and used for filtering report results.

Related content

Formula Fields
Formula Fields
More like this
Formula Fields
Formula Fields
More like this
Conditional Logic
Conditional Logic
More like this
Syntax, Operators, Functions
Syntax, Operators, Functions
More like this
Some examples
Some examples
More like this
Some examples
Some examples
More like this