Expression/text label

[#1]

Hi! I'd like to create a label to show a text like this: "150 - Company A", where 150 is a value selected from an input box,(vBusiness) and "Company A" is the name of number 150 company. How can I write this expression?

Is it correct the use of this expression?

='Title:' & ' ' &  (vBusiness)& ' ' & ({$<NumberCompany ={$(=vBusiness)}>}[NameCompany])

Any suggestions greatly appreciated.

Regards,

Andrea

[Gysbert_Wassenaar]

Assuming that vBusiness is a variable that contains a numeric value... try this:

='Title: ' &  $(vBusiness)& ' ' & only({$<NumberCompany ={$(vBusiness)}>}[NameCompany])

[CELAMBARASAN]

May be like this

='Title:' & ' ' &  (vBusiness)& ' ' & Only({$<NumberCompany ={$(=vBusiness)}>}[NameCompany])

[vipin_mishra479]

Hi,

Use This

='Title: ' &  $(vBusiness)& ' - ' & only({$<NumberCompany ={$(vBusiness)}>}[NameCompany])