I think I did not express correctly. I will try to explain once more.
I use the above code in an expression of a chart to display the name.
As in the code given I assume there that only one name is present and according to that if there is no name I get a "-"
If there is a name and the length of the letters is less than 25 which is the maximum row length in the Chart then write it in oneline and then with a line gap write the tarifgruppe
Now the question is..
How can I change the above code if there are many names. If I have two or more names in my output i get a "-" in the display of chart.. I wonder why I get "-". As in code only when it is Null it must give a "-" not when there are more names..
Sorry, if i didn't understand your problem correctly. You are displaying Employee Name as an Expression, right? In expressions, if multiple value exists, we have to use aggregation functions like sum(), Min(), Max() to get the proper output. Otherwise, there should exist only one value for that expression. In your case, you can create a pivot table with
Thanks for the suggestion but how can I write a aggregation function in my case to display multiple values if they exist. If there is only one value my code which is given above works.. Can you pls suggest a code which gives multiple values from the above given code.. Thanks in advance...