I did try it as already explained. And in every section of the report. Both with my expression and the one you suggested. All to no avail. One thing I did notice was that when the fields are in the footer, and I run the report, it prompts me to enter a value for the Unit Price. Unit Price has this expression:
Code:
=IIf([Ordr Total]>[Price Break4],([Price Break4 Cost]*[Ordr Total]+[Shipping Charges])/[Ordr Total],[Cost])
I triple checked for any typing errors making sure control sources were correct. Everything looks fine.