Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,334
Community Members
 
Community Events
168
Community Groups

How to concatenate strings in EazyBI?

Edited

Hi guys,

I have a calculated member in the measures that always returns me a key of type string.

example '123'

I need that in the column where this calculated member is displayed he grabs the key(123) and concatenate with the word "IDEA-", getting like this:


IDEA-123


I can't do  ->   'IDEA-' + [Measures]. [KEY] = IDEA-123


Does anyone know how I can do that?

2 answers

Anyone knows about doing that? @Jm Ll 

Hi,

Try this formula when creating a new calculated measure:

 

"IDEA-"||[Measures].[Key]

 

Martins / eazyBI support

 

example.png

Like Josep Lluis Perez likes this

Thank you!! It's working

 

Josep

I recently ran into this same problem and contacted EazyBI support.  They informed me that the || operator was used for string concatenation.  An odd choice--and undocumented as far as I could tell--but it works.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Apps for Confluence you won't want to miss: RSVP for September's Appy Hours

Calling all collaborators and Confluence users! Our Appy Hours event on September 29th features 4 presenters demoing functionality to superpower Confluence. Don't miss learning about these apps i...

122 views 0 9
Read article

Atlassian Community Events