I am wondering if the following is possible to do within ExpressionEngine:
On the front end of the site, I would like ExpressionEngine to search a particular custom field within a particular channel, and add all of those numbers together to come up with a sum total. So for example...I have a channel named "Invoices" and within that channel, I have a custom field named "Monthly Total" which only has numbers and a decimal (ie. 15.25). On the front end of the website, I would like to display the sum total of custom field named "Monthly Total" for every single entry in that channel. So essentially, this front end section would automatically update when a new channel entry is created or deleted.
I hope that made sense, can this be done? Thanks!