Hi ,
I have report in ssrs. I have fields which mention last year sales,this year sales in dollers as well as in percentage. Now I get the record from SP as thousand seperated values like following :
REPLACE(CONVERT(VARCHAR,CONVERT(MONEY,ROUND(sum(A.TY_SalesDollars),0)),1), '.00','')as TY_Sales,
REPLACE(CONVERT(VARCHAR,CONVERT(MONEY,ROUND(sum(A.LY_SalesDollars),0)),1), '.00','')as LY_Sales
I get values in fields with thousand seperator. Now I want to get SUM of this column in SSRS. When i use
SUM(Fields!TY_Sales.Value) I got below error in Total field -- > '#Error'
Can anyone give me idea to resolve this? Thanks in advance
Loading
Sibeesh VenuPosted Apr 28, 2015, 3:13 AM
Have you tried the SUM function after removing the thousand separator from the numbers?
Please up vote and accept if it helps you.
Kindest Regards
Sibeesh Venu
www.sibeeshpassion.com
Sibeesh VenuPosted Apr 29, 2015, 12:55 AM
Kavitha MPosted Apr 28, 2015, 5:03 AM
Thank you for your suggestion. I tried it by removing seperator in SQL query and use
"=Format((Fields!TY_Sales.Value),"#,##")" in SSRS . Now I can able to get SUM of these columns.