To Set Up a Calculated Property

Use calculated to come up with a calculated property by concatenating multiple fields’ data.

1. Click Home tabProject panelProject ManagerProject Setup.
2. In the Project Setup tree view, expand P&ID or Plant 3D Class Definitions.
3. Continue to expand the list until you locate and click the class definition whose property you want to add.
4. On the Class Settings pane, under Properties, click Add.
5. In the Add Property dialog box, do the following:
   

   • Under Property Name, enter a name for the new property (for example, prop_name). The name cannot contain any spaces.
   • Under Display Name, enter the name you want to be displayed for the new property when using the Data Manager or Properties palette (for example, Prop Name).
   • Under Choose a Type, select Calculated.
6. Click OK.
7. In the Add Calculated Property dialog box, choose the format of the new property (for example, String).
   

8. Choose existing functions and operator symbols to concatenate multiple properties. The calculated property expressions display on the right pane. You can also directly enter the SQL statement.

   Sample expression: ToUpper(Service) ||('-') || LineNumberTag || ('-') ||Spec

   Calculated property result:

   Note: The double bar "||" is used to separate each field or text. Text or special symbols must be encapsulated by parentheses and a single quote (for example, ('text')).
9. Click Add Property.

   On the Class Settings pane, under Properties, the calculated property is displayed for the selected class definition.