LEFT() expression in inline tables

Hi all,

Does LEFT() expression work in inline table views? I have an inline table with a column that has very long text and so I want to use the expression as LEFT([Column name], 5) to only have 5 characters visible in the inline table views?

I tried it and didnโ€™t work, so maybe I am missing something.

Thanks

Solved Solved
0 2 150
1 ACCEPTED SOLUTION

ahhhh I seeโ€ฆ I must have misunderstood the expression. Ok I think creating a different column with 5 characters would be a better option.

Thanks heaps Steve!

View solution in original post

2 REPLIES 2

Steve
Platinum 4
Platinum 4

LEFT() can be used anywhere an expression can be used.

Thatโ€™s a different question. To display a different value than actually exists in the column, youโ€™d have to create an additional (optionally virtual) column that contains the alternate value, then reconfigure the view to display that alternate-value column instead of the original.

Have you already explored reconfiguring the inline view?

ahhhh I seeโ€ฆ I must have misunderstood the expression. Ok I think creating a different column with 5 characters would be a better option.

Thanks heaps Steve!

Top Labels in this Space