The concat formula is used to combine multiple attribute values into one badge. For example, you may have a badge for the parent company and the operating company. The concat formula can be used to combine the two attributes into one badge instead of two.
Note: All attributes that are referenced in the concat formula must be included in your view set but do not need to be enabled as badges.
Note: Badge values cannot be modified from the formula badge.
Format: concat (attribute1, attribute2...,>)
To string attributes together, list all attributes separated by commas within the formula. After the last attribute put a comma and then the character that will be used to separate the attributes.
Example:
-
concat (ParentCompany,OperatingCompany, >)
-
-
The resulting badge would look like this: ARCOS Power > Columbus
-
Reminder
The formula, attribute name and data point must be spelled and in the same case as the formula, attribute or data point you are referencing.
E.g. If an attribute is called CrewType, in the formula, you must use CrewType. crewType and CREWTYPE will not reference the CrewType attribute.
Comments
0 comments
Please sign in to leave a comment.