Getting a Total amount in Access Report

I ‘m having trouble getting a total amount to appear in the footer of my Access report. I’ve been through the Access help documentation, I’ve written the formula in various ways, I’ve tried pulling the data from a table and a query, but I always a “#Error”. I can drag my text box with the formula up into the detail section and it will work fine.

What’s the secret?