The previously mentioned constant values (see Constant Values) and dynamic values (see Dynamic Values) can not only be used on their own, but they can be used in calculations by using the following operators:
The syntax to concatenate the texts Hello and World is as follows:
|"Hello" & " World"|
You cannot only use constant values in these expressions; you could, for example, use the following expression to add value of the datasource field NetAmount and the value of the datasource field VatAmount; we assume here that these fields are both in the datasource Invoicing.
|[Datasource].[Invoicing].[Field].[NetAmount] + [Datasource].[Invoicing].[Field].[NetAmount]|
You can also mix constant values and dynamic values in these calculations; if you want to divide the datasource field YearlyRevenue of datasource Invoicing by 12 (e.g. in order to get an average monthly revenue value), you can use the following syntax:
|[Datasource].[Invoicing].[Field].[YearlyRevenue] / 12|
The dynamic values used do not necessarily have to belong to the same datasource; you could also write expressions which calculates values from different datasources, combined with constants.