Help with i number in a textobjekt

[#1]

I need help in a text object.

Outcome: (= Sum ([Sum]))

Ultimate goal: xxx

But how do I get it so that I get a calculated variable between text variables.

I select the text so no way to type "or is there some other way, I need help stuck

[swuehl]

Not sure if I understood correctly, maybe like:

= 'Outcome: (' & sum([Sum]) & ')'

i.e. concatenate two string literals and the result of the sum expression.

[#3]

Hello again!

Now I have the formula = 'Outcome' & sum ([sum]) & 'Ultimate goal: xxx

But I need to make a line break at the Ultimate goal, how do I do it?

[#4 · Accepted solution]

Hello!

I solved the problem

= 'Outcome' & sum ([sum]) & Chr (10) & 'Ultimate goal: xxx'

show my solution above

thanks for the help

[#5]

Hi,

try this......

= 'Outcome' & sum ([sum]) & chr(13) & 'Ultimate goal: xxx'

[jfkinspari]

You can either use the function chr(13) making the expression look like this

='Outcome' &sum ([sum]) & chr(13) & chr(13) & 'Ultimate goal: ' & sum ([sum])

Or you can just use '' across lines, like

='Outcome' &sum ([sum]) & '

Ultimate goal: ' & sum ([sum])