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