CODEWITHSUNDEEP
matrixreporting-servicesssrs-2008rdlc
محمد قاسم
محمد قاسم

Reputation: 179

SSRS - Row Total for Particular Column Value in matrix

In SSRS,I'd like to add a column that shows the total count of all Late, Annual Leave & Sick Leave data for each individual row.

Currently, I'm just working on Late column & getting error on report like this. enter image description here

by using following setting.. enter image description here

this stack-overflow Solution isn't working as well

ThankYou...

Upvotes: 0

Views: 1591

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

I think your issue related to Count field. It is possible that for some reason it is returning strings, hence SUM function cannot sum its values.

Try:

=SUM(IIF(Fields!Activity.Value="Late",CINT(Fields!Count.Value),0),‌​"EnrollId")

Let me know if this helps.

Upvotes: 1

Related Questions