How to concatenate two strings in calculated field?

Questions & Answers
1

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

2

[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

2 Likes
3

Hi,

Please try the approach @malikgp shared.

Thanks!
Best regards,

4

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.

Gap linked to Epic Concatenate(Combine two measures) in Eazybi
Gap linked to Epic Concatenate(Combine two measures) in Eazybi844Ɨ231 19.7 KB

Measure Used:
[Measures].[Gap ID] || ā€œā€“ā€ || [Measures].[Issue GAP ID]

Regards,
Revathy.M