Hi guys,
Basic question but i don't see the solution :(
I have 3 computed fields on my datawindow 1 with text , 1 decimal with European number formatting (being 1.234,56 ###,###.00) and another computed text.
Concatenating these 3 will loose the formatting of the decimal computed field.
Example
compute_1 = 'Abcdef'
compute_2 = 1.234,56
compute_3 = 'defghij'
compute_4 = compute_1 + ' ' + compute_2 + ' ' + compute_3 gives me as result = 'Abdcdef 1234.56 defghij'
Due to the variable length of compute_1, i can't 'hardcode' the position of my column instead of using computed field.
How can I keep the formatting inside my concatenation please ?
What am i missing here ?
TIA
John
It should look like this:
compute_4 = compute_1 + ' ' + string(compute_2, '###,###,##0.00') + ' ' + compute_3
Result: 'Abcdef 1.234,56 defghij'
Dirk