Expression Label - Label on two lines

[Anonymous]

Hi,

I'm making a straight table & in that table, I would like to label my expressions.

I'm trying to get my label divided over 2 lines.

Code:

='Netweight '&(max(Year)-1)

This label would be:

Netweight 2011

I would like to make it this:

Netweight

2011

Does anyone know if this is possible?

Thanks!

[#2]

Try with this expression:

='Netweight ' & chr(10) & (max(Year)-1)

A greeting.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Following the idea by Daniel, this might work as well, if the Chr(10) alone does not:

='Netweight ' & Chr(10) & Chr(13) & (Max(Year)-1)

Hope that helps.

Miguel

[jonathandienst]

Hi

There is a simpler way. Click the edit expression button, and press enter inside the string, like this

='Netweight<enter>

' & (max(Year) - 1)

Hope that helps

Jonathan