Add text to lable

[#1]

I am presenting data by quarter, with the labels generated by formula.  I would like to add text after it displays the quarter. Here is one of the labels:

=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0))

This displays the current quarter, but I would like to add the text 'Listings' after it. Can anyone help?

[#2]

Hi,

Try you made a table box whit only field listed?. i think that would be good.

[rwunderlich · Accepted solution]

=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0)) & ' listings'

[#4]

Thanks. How can I format QuarterName to show 1Q12, instead of Jan-Mar 2012?

[jagan]

Hi,

Try this

=Ceil(Month(Today())/4) & 'Q' & Right(Year(Today()), 2)

Regards,

Jagan.