SSRS And Expression not working

Question

I have an expression in SSRS like this.

IIF(First(Fields!val.Value, "box29")="Yes" AND Sum(Fields!SortOrder.Value, "InsuranceInformation") > 1,"",

Valu val is Yes and Sortorder is 2. That is both expression satisfying. But this expression is not satisfying with AND. Any idea on this?

Answer 1

I think you need to finish your expression:

=IIF(First(Fields!val.Value, "box29")="Yes" And Sum(Fields!SortOrder.Value, "InsuranceInformation") > 1, "And expession statisfyed", "And expression not statisfyed")