Hi,
how can I concatenate two strings in calculated field? I just need to add a special prefix to an existing string field. Your documentation is silent about this.
Thanks,
Radek
Hi,
how can I concatenate two strings in calculated field? I just need to add a special prefix to an existing string field. Your documentation is silent about this.
Thanks,
Radek
[Measures].[String 1 example] || " " || [Measures].[String 2 example]
You use || for appending, and can add any delimiter you choose. In the example above I used a space as the delimiter.
Hope this helps.
– Malik Graves-Pryor
Hi @martins.vanags ,
I tried the above scenarion & i got the expected value but along with the value it also displays null.
Could you please help me to remove the null string from the report.
Measure Used:
[Measures].[Gap ID] || “–” || [Measures].[Issue GAP ID]
Regards,
Revathy.M