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.

Request a demo

Fill in our form and one of our colleagues will contact you as soon as possible to schedule a demo.

Please enable JavaScript in your browser to complete this form.
Please enable JavaScript in your browser to complete this form.

Download the whitepaper

Please enable JavaScript in your browser to complete this form.
Addresss

Get in touch

Fill in our form and one of the Relatics members will contact you as soon as possible. Do you prefer contact by phone? Please call us at +31 180 413 047.
Please enable JavaScript in your browser to complete this form.