just to show you where I got that information from...

http://www.sqlservercentral.com/Forums/FindPost468368.aspx

I've gone ahead and put everything into one expression and things are exactly how I want them. Thanks for the...

I had that originally. But then I read somewhere, I believe on here, that the hidden property always takes the last option in the if statement...

so in this case...

=IIF(fields!Addr2.Value...

I've tried hiding Addr2 and I 'think' that I'm doing it right and still not getting the results that I'm looking for.

For the hidden expression I have: fields!Addr2.Value is...

Thank you! the second solution is what I was looking for.

I need to be more specific. 🙂

EmpExp, Emp, and, MiscExp are all fields from the dataset.

textbox 1 = sum(EmpExp)/Count(emp)

textbox 2 = sum(MiscExp)

what I need is to have a 3rd...

I was looking to do it as an expression in the report itself.