We can also use expressions to manipulate text. Let’s say that we have 'ShipCity' (e.g. Berlin), as well as 'ShipCountry' (e.g. Germany).
Using the following expression:
[ShipCity], + ‘, ‘ + [ShipCountry]
This would combine ‘Berlin’ and ‘Germany’ to ‘Berlin, Germany’. Note that in order to add text, we use single quotes. Anything between single quotes will appear exactly as typed, in this case a comma and single space.
In the same as in the example, we can add a static text denomination to a numerical value:
[Freight] + ‘USD’ -> xxxxUSD
We could also write:
‘$’ + [Freight] -> $xxxx
Last edited by Joseph Adams, 2014-04-02 15:13:47