How to concatenate two strings in calculated field?

eset_janata · August 24, 2018, 9:51am

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

malikgp · August 24, 2018, 7:00pm

[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

martins.vanags · September 12, 2018, 1:45pm

Hi,

Please try the approach @malikgp shared.

Thanks!
Best regards,

RevathyMadhavan02 · February 14, 2023, 9:03am

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