Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pecunn
Starting Member
20 Posts |
 Posted - 2011-04-28 : 04:51:36
|
| Hi guys,i have chart showing monthly sales based on financial year. In legend i want to put total sales for financial year. This is my expression="Financial Year " + CStr(Year(Today())-1) + " = #TOTAL"This #Total is showing total sales as numeric not currency.I did try use FormatCurrency function however it always give me an error.if someone can help me much appreciated. |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-28 : 10:14:00
|
| What does the error say?Hey, it compiles. |
 |
|
|
pecunn
Starting Member
20 Posts |
Posted - 2011-04-28 : 20:39:45
|
| The errror saying expression expected.This is what i did.="Financial Year " + CStr(Year(Today())-1) + " = " + FormatCurrency(#TOTAL) |
|
|
|
pecunn
Starting Member
20 Posts |
Posted - 2011-04-29 : 01:24:44
|
| i fixed the problem by using FormatCurrency(SUM(field.value),0) instead of using #TOTALThanks |
|
|
|
|
|
|
Convert #total to currency