Showing Percentage in SSRS Tablix

Question

I am using Visual Studio 2012 and SQL Server 2012. My question is concerning how to show percentages in my SSRS Tablix based on fields I currently have.

I have a WithinRequirements field that I used a case statement to tell me if a particular Business_ID falls within the requirements or not. In this case, if a Business_ID with the name Headquarters is completed within 10 days, then it receives a 1, if not then a 0.

CASE WHEN AgeBusiness >= 0 AND AgeBusiness <10 AND [Name] like '%Headquarters%' THEN 1
ELSE 0
End AS WithinRequirements

From that, applying my filters and rest of query, I get about 601 Business_ID records that either result in a 0 or a 1.

Now I am trying to create a column in my tablix to show percentages for WithinRequirements.

Basically, I am trying to get an expression in SSRS for the column that says:

(Count of Business_ID where WithinRequirements = 
                1/Total Number of Business_ID where WithinRequirements = 1 or 0) * 100)

I'm not sure how to make this expression. Can anybody help me out with this? I tried:

= Count(Fields!WithinRequirements.Value)/Sum(Fields!WithinRequirements.Value)* 100

as my expression, but that is not working.

Any help would be appreciated and thank you in advance.

Answer 1

Try this

Sum(Fields!WithinRequirements.Value)/Count(Fields!WithinRequirements.Value) * 100