SSRS Using WHERE in a calculated field

Hi LB79,

I already notice that the values for ID20 field are "IN" and "OUT", not "In" and "Out". This should be the reason why the expression returns 0. So please refer to the following expression:

=sum(iif(Fields!InOut.Value ="IN", CDbl(Fields!ID20.Value),CDbl(0)))-sum(iif(Fields!InOut.Value ="OUT", CDbl(Fields!ID20.Value),CDbl0)))

If there are any other questions, please feel free to ask.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support