Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello!
I solved the problem
= 'Outcome' & sum ([sum]) & Chr (10) & 'Ultimate goal: xxx'
show my solution above
thanks for the help
Not sure if I understood correctly, maybe like:
= 'Outcome: (' & sum([Sum]) & ')'
i.e. concatenate two string literals and the result of the sum expression.
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?
Hello!
I solved the problem
= 'Outcome' & sum ([sum]) & Chr (10) & 'Ultimate goal: xxx'
show my solution above
thanks for the help
Hi,
try this......
= 'Outcome' & sum ([sum]) & chr(13) & 'Ultimate goal: xxx'
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])