Formula
Formula can use a combination of static strings or characters, reserved keywords or reference other global attributes or attributes defined within the same asset class.
Reserved keywords
$class : Name of asset class
$classcode : Code of asset class
Reference another attribute
$attribute.Attribute Name
Example: $attribute.Serial Number
A formula can combine static words with dynamic value. All dynamic values must be
encased in [ ] or { }
[$classcode]-[$attribute.Design ID]
[ ] - The value is mandatory and will be included even if the reserved or attribute value is
missing.
{ } - The value is optional and will be skipped if reserved or attribute value is missing
Example 1>>
[$classcode]-[$attribute.Design ID]
Let's assume class code is L123 and Design ID is missing.
The output will in this case will be "L123-"
Example 2>>
[$classcode]-{$attribute.Design ID}
Lets assume class code is L123 and Design ID is missing.
The output will in this case will be "L123"
Escape character: In order to escape ',' use \
Maintenance Depot\, [$classcode]-[$attribute.Design ID]
Updated about 2 months ago