I've been banging my head against this one, but I have a query that I setup for inventory use.
In that query, some fields use a formula. I, then, added a Totals row to it.
I have a few, like the one shown below, that I set to Sum, but it won't show it. It will show Average/Min/Max/etc, but...