Concat number and text in calculated field

Ingo Klose shared this question 2 years ago
Answered

Hi,


We have a requirement where we need to concat a number and some dynamic descriptions from a different field. The result should be visible in one field, But that does not seem to be possible in the calculated filed. Do you have any idea how we could achieve this?


Best regards,

Ingo

Comments (5)

photo
1

Hi Ingo,

Thanks for getting in touch. In most cases it is possible to simply add the fields together. If one of those is a text field, Yellowfin will treat the addition as concatenation:

e489a76b5d23617d60229f72ccfc971c

Are you able to get this working?

Regards,

Nathan

photo
1

Does that also work with cross tab reports?

photo
1

Hi Ingo,

The data within a cross-tab report needs to be an aggregated metric field. As combining a metric and text will result in a dimension field, you will only be able to use it as a column or row header, which may produce poor results as seen below:

58b72056d2111f121fc89e6a76117e8e

photo
1

OK, thanks.

photo
1

Hi Ingo,


I switched this to closed, if you have any more questions on this please just respond and the case will be re-opened.


By the way: I have found an interesting function that may be of use to you:

http://community.yellowfin.bi/topic/aggregate-a-text-column


Regards,

Nathan