I have a report with a dataset that has a column with booleans. In the table footer I want to display `x / y` where `x` is how many rows that were `true` and `y` is how many rows there was total.

Currently I have this:

```
=Count(Fields!Transfered.Value).ToString() + " / " + CountRows().ToString()

```

But the first becomes same as the last part. I then tried this:

```
=Sum(Fields!Transfered.Value).ToString() + " / " + CountRows().ToString()

```

But that generates an error, which I guess I can understand. I thought that if I converted the booleans into numbers where true is 1 and false is 0, then it could work out nicely. But how can I do that? Or is it a smarter way to do this all together?

**Update:** Have now also tried

```
=Sum(CInt(Fields!Transfered.Value)).ToString() + " / " + CountRows().ToString()

```

And got a negative result... O.o

Also found a way that worked, which I posted as an answer. But I won't accept it as an answer yet incase someone has a better way to do this =)