[Resolved] Calculate a column total from a view

[Author]

Posts

[larryB-3]

I have a page that displays a couple of different views. hidden link

For each view, I'd like to calculate the total of the dollar amounts listed in the last column. So basically at the bottom of each table that the view created, have a row that shows total $ amount for the items listed in that table that were returned from the view query.

[Christian Cox]

Hi, there aren't any mathematical summation features built into Views so the only way to achieve this is through custom code. Another ticket here in the forum discusses an approach that works with integers ( requires 1000 instead of $1,000 ):
https://toolset.com/forums/topic/calculate-a-running-total-on-a-view/

So if you have a custom field that holds only the integer price, you could add that in the loop and hide it with CSS, then perform the calculations based on that hidden number.

[larryB-3]

Thanks for the information.