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.