Old SQL Newbie
Ten Centuries
Points: 1060
More actions
April 24, 2008 at 9:41 am
#189418
="Avg Sales Fiscal"& FIELDS!FiscalYear.Value &": "& round(avg(Fields!SalesAmount.Value),2)
Is there an expression I can use to format this similar to Currency two decimal places. (with a comma for thousands).
TIA!
April 24, 2008 at 11:07 am
#806749
Figured it out...
format(AVG(FIELDS!SalesAmount.Value),"###,###,##0.##")
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply