Work with formulas in a calculated property

Work with formulas in a calculated property

A calculated property is a dynamic value based on other property values within the same element. The value of a calculated property is determined by using a configured formula.

Formula syntax

The following syntax can be used to create the formula:

Syntax Description Example
 + Addition 2 + 4
 – Subtraction 6 – 1
 * Multiplication 2.1 * 3
 / Division 6 / 3
 ( ) Parentheses (4 + 5) / 3

Fixed values in a formula

Fixed values ​​can be used for calculations in a formula. The value can be positive or negative, containing a dot as a decimal separator.

Example to convert Celsius to Fahrenheit:

({degrees Celsius (°C)} × 1.8) + 32

Number properties in a formula

To use a number property in the formula, the property name should be placed between curly braces ( {property name} ).

Example to calculate the surface:

({Length} * {Width})

Note:

  • A number property configured as calculated is not allowed in a formula.

List properties in a formula

The list property has a feature dedicated to formulas. A number value ​​can be linked to the list property items.
To use the list property in the formula, the property name and attribute name, separated by a hash ( # ), should be enclosed within curly braces ( {property name#attribute name} ).

Example to calculate a risk score:

({Chance#Factor} * ({Impact - Money#Term} + {Impact - Time#Term}))

Back
Schakel JavaScript in je browser in om dit formulier in te vullen.

Download the whitepaper

Schakel JavaScript in je browser in om dit formulier in te vullen.

Download the whitepaper

Request a demo

Fill in the below information and we will contact you to schedule a demo.

Schakel JavaScript in je browser in om dit formulier in te vullen.
We will use this information to contact you.
Schakel JavaScript in je browser in om dit formulier in te vullen.
Schakel JavaScript in je browser in om dit formulier in te vullen.
Addresss

Neem contact op

Vul ons formulier in en een van de Relatics medewerkers neemt zo snel mogelijk contact met u op. Liever telefonisch contact? Bel ons op +31 (0) 180 413 047.
Schakel JavaScript in je browser in om dit formulier in te vullen.