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.