4 Replies Latest reply on May 15, 2012 9:38 AM by Tracy Rodgers

# labels for multiple fields

Is there a way to concatenate two fields for a label?

for example if I am looking at a product, i want the label to show # of people and avg \$ amount per order.  For example:  (23); \$15. In excel the formula would have been =count(EE)&average(\$ amount)

• ###### 1. Re: labels for multiple fields

Hi Betty,

You can concatenate two fields for a label by creating a string out of the measures. Similar to the following calculation:

"\$" + left( str(sum(Sales)),1) + "," + mid(str(sum(Sales)), 2, 3) + " %" + str(round(avg(Discount),2))

The above calculation will vary depending on how you want the output to look.

Hope this helps!

-Tracy

• ###### 2. Re: labels for multiple fields

Yes that worked.  Thank you!

• ###### 3. Re: labels for multiple fields

Is there a way to round or just show the numbers to a certain place (e.g., to the thousandths place).  I tried the left function but it is triming the number vs. rounding it.

Thanks!

• ###### 4. Re: labels for multiple fields

Hi Betty,

There is a ROUND function that will allow you to do this. You can specify the number of decimal places.

-Tracy