Hi Geoff5,

I am just learning SSRS and wish you could help me.

If activity code is between 50 and 65, I will count unique applicationNumber

However, The following expression does not work.

=CountDistinct((IIF(Fields!ActivityCode.Value) BETWEEN 50 and 65,

Fields!ApplicationNumber.Value,NOTHING)

Thanks

Frank