Forum Discussion
wshalex123
3 years agoHelper III
Measure expression
Hi, i got a calculated table which shows the next jubilees of my employees: When creating a table visual it looks like this: Note: I created seperate columns for the strings like "...
wshalex123
3 years agoHelper III
Hi Greg,
the order of the columns is correct and i know how to sort them of course.
I just want the result to be a "whole" sentence with the same space between all values.
Greg_Deckler
3 years agoCommunity Champion
wshalex123 CONCATENATEX
- wshalex1233 years agoHelper III
Greg_Deckler
I tried to change it to your suggested formula. When leaving the "order by expression" gone, i shows me a whole sentence of both entries combined.I would like to have both entries in different rows. i tried it with the "order by expression" but it shows me following error:
- Greg_Deckler3 years agoCommunity Champion
wshalex123 OK, I am confused. First you want a whole sentence and now you don't. Mabye try using UNICHAR(10) as your seperator so that you get a line break?