Like I stated, the report runs with no problems but instead of showing the value of the Sum expression I get "#Error" on the report in place of the calculated value.  I am getting this regardless of either function I use.  I do not see where a description of the error message is.

I am going to create another report and keep everything simple just to test the formula.  If you could explain how you tested, I would appreciate it.