Text + expression in button

[#1]

Hi

I have created a button that links to a sheet in my QV with some text.

After this text i want to have the summary of an expression shown.

In text field for the button i can put my expression =sum (if ([Level 1 Tryck]='Line_3612', P2_tryck='x'or P2_tryck='X')*-1) and this is ok but i also want the text BD 3612 to show in the button.

Is it possible to mix text with an expression so they are both visible on the same button?

Best regards

/Mats

[tresesco · Accepted solution]

Try like:

='Your text' & expression

Note: '&' is used to concatenate strings

[#3]

Yeah you can do that following the folliwing format: '='your text' & function.

='sales are ' & sum(sales)

[#4]

'BD 3612' & sum (if ([Level 1 Tryck]='Line_3612', P2_tryck='x'or P2_tryck='X')*-1)

The & is used for string concatenation