March 26, 2012 at 5:22 am
Dear all,
I'm trying to create a percentage in reporting Services by using the following:
=(Fields!ThisWeekTotal.Value)/SUM(Fields!Total.Value
But I get #Error in the column, would anyone let me know how I would be able to resolve it please?
Thank you!
March 26, 2012 at 5:35 am
is that the exact text which is in the expression? if it is your missing a )
March 26, 2012 at 7:13 am
Thank you for the reply!
No, the expression is: =(Fields!ThisWeekTotal.Value)/SUM(Fields!Total.Value) but it still gives an error
Thank you!
March 26, 2012 at 7:22 am
what if you wrap the whole expression in ()
other than that, would need to see the data to figure out whats happening
March 26, 2012 at 9:35 am
Thank you for your reply!
The report result should look like the following:
City TotalCount Percentage
London 41
Germany 27
..
..
TotalNumber TotalNumber%
Thank you!
March 26, 2012 at 5:47 pm
Might be a divide by zero error. See the 3rd response (from Toolman) in this post:
http://www.sqlservercentral.com/Forums/Topic537901-150-1.aspx
March 27, 2012 at 1:20 am
tt-615680 (3/26/2012)
Thank you for your reply!The report result should look like the following:
City TotalCount Percentage
London 41
Germany 27
..
..
TotalNumber TotalNumber%
Thank you!
thats what it should look like but what is the raw data behind the report to make it look like that,
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply