CODEWITHSUNDEEP
reporting-servicesreportingpercentage
ikilledbill
ikilledbill

Reputation: 219

Add percentage to SSRS report

I have a table in my SSRS report.

enter image description here

As you can see to the right hand side I have a column called %. How can I calculate this? The only way I know how is to take the [Count(AssetId)on the row above the total line (this is Textbox11) and divide it by the [Count(AssetId)in the total row (this is Textbox8). So basically how do I dive two text boxes together?

enter image description here

So basically I want to divide the 573 by 1025 (my total) in order to get a percentage.

Upvotes: 3

Views: 105

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

Try this expression in the % column:

=Count(Fields!AssetId.Value)/Count(Fields!AssetId.Value,"DataSetName")

Change DataSetName by the actual name of your dataset.

Let me know if this can help you.

Upvotes: 2

Related Questions