Show total inventory cost in a single cell

[KlodgeRDS]

Building a Inventory App and I have everything working. The last thing I have  is killing me. I am trying to figure out how to limit the Inventory Total to one cell right now it is shwing next to each item. 

[Aurelien]

Hi @KlodgeRDS 

This is because every expression in your table is calculated for each row.

If you want a "grand total", you may want to create a new table, let's says "Summary", that will hold only one row, and to which you can attach your expression for grand total.

And, of course...create a view based on this one.