SSRS Using WHERE in a calculated field

Hi LB79,

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