The concatenation function is used widely to form a combined text string from several independent text variables which can include anything, with the most widely used variables being attributes and properties such as name and categories. It is extremely useful in forming a WBS structure on the timeline view, to be able to show a roll-up functionality within the timeline.
Syntax
CONCAT([x,x,x,x,])
Parameters
x = any variable you wish to be combined into a single string
Type of Data Returned
Will return a string
Examples
CONCAT([“SharpCloud ”, ‘ ‘, “Software”, ‘ ‘, “Ltd”]) will return SharpCloud Software Ltd
Using the CONCAT function to form a WBS structure, where the items are Projects and they have an attribute called Programme, showing what Programme the projects belong to:
CONCAT([Programme, “.”, name]) will return Programme 1.Project 1 for example, which could then be displayed on the Y-Axis.