Adding Text before Expression not working

[rustyfishbones]

Hi All,

I have the following Expression which works fine

I get the correct answer of 28, however when I had text before it I get -

See below image, it says the expression is ok, it should give me a result of L3 28

Can you help

[abeyphilip · Accepted solution]

Hi Alan,

I think you will have to add one more bracket for the two sum expressions like the one below:

='L3 '&' '&(sum(expr1) - sum(expr2))

rgds,

Abey

[rustyfishbones]

Excellent, that's it thanks