Calculated properties can now be added from the Project Setup for both P&ID and 3D piping classes. It enables a singular field to create data based on concatenating multiple fields’ data and defined values into one value.
You can choose Calculated when adding new properties from the Project Setup.
In the Add Calculated Property dialog box, choose existing functions and operator symbols to concatenate multiple properties. The calculated property expressions display on the right. You can also enter the SQL statement directly in the Calculated Property Expressions box.
Sample expression: ToUpper(Service) ||('-') ||LineNumberTag|| ('-') ||Spec
Result calculated property:
Note: The double bar “||” is used to separate each field or text. Text or special symbols must be enclosed by parenthesis and a singular quote (for example, (‘text’)).