Use a calculated property

Use a calculated property

A calculated property is a special property that derives its value from the result of a formula. This can be used for calculations. For example, to give an element a score to determine its weight relative to other elements or to calculate a surface or volume.

The value is determined by using a preconfigured formula. The result value can be used in filters and sorting. A user can not change the value directly.

Note:

  • While the value of a calculated property is not editable, it is possible to set the role permissions of the property to edit. This will not change the fact that a calculated property is not editable.

Identify a calculated property

A formula symbol () is added to the tooltip of the property name, indicating that a property is of the calculated property type. You can recognize the value of a calculated property by its italic font.

Interpret error messages

Until all the property values used in the formula are set, the calculated property will stay empty. A calculation can result in a (mathematical) error. The following error messages can be presented:

Error Cause
#Div/0!  The #DIV/0! error shows when a number is divided by zero (0).
#NUM!  The #NUM! error shows when the calculated value is greater than 100 000 000 000 000 000 (1e17).

Create a calculated property *

  1. In the workspace menu, click on Type graphview.
  2. In the model, click on the type element to which a new type property should be added.
  3. In the toolbox, click on  New type property. As a result, the dialog New type propety is opened.
  4. Enter the desired name in the field Name.
  5. Set the Data type to Number. This results in an update of the dialog whereby the fields Precision and Configuration are added.
  6. In the field Precision, enter the desired amount of decimals the number property must show.
  7. Set the Configuration to Calculated. This will trigger the dialog to show the field Formula.
  8. Enter the Formula.
  9. Click on Create.
* In the workspace, the user type of your user must be set to power user to use this feature.
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.