Total from an expression in SSRS

0
votes

I have written an expression and added it to a calculated field:

=IIF(fields!date1.value

The calculated field now returns either 1 or 0.

I want to now get a total of all the 1's, but when I try and get a total: =count(fields!totals.value = 1) then it just totals every row in the report, e.g. the total counts the 0's as well.

Please can someone advise how to get get a total of just the 1's? - e.g., sift out the 0's?

Many thanks

1
ssrs-2008-r2

1 Answers

0
votes

If my understanding is correct, it is a SUM operation. In your tablix total field input the expression like "SUM(fields!totals.value = 1)"