I am trying to get the sum of a field across a list of nodes in a view. Heres the scenario: I have a content type called "mileage" which allows each user to enter the mileage on a single bike trip. I would like to create a view that displays one list item for each user with a sum of the mileage nodes from that user, one "total" number.

Any help that can point me in the right direction would be great!

Comments

egsj’s picture

egsj commented

Also trying to do this.

jon_stewart’s picture

jon_stewart commented

Working out stock value from shop.

In my case, trying to use this to list stock_item_volume x cost_price, to work out a line value, then sum the line values, so that I have total value of stock in store for accountancy purposes.

The logic is trivial, except when you consider how Ubercart, Views, and views calc interract to give me a number of lines and a sum that is approximately 3 times what they should be.

Another puzzle!

okeedoak’s picture

okeedoak commented

Subscribing, 'cause I think this will require custom code.

JohnnyBeGood-dupe2’s picture

JohnnyBeGood-dupe2 commented

I've solved something similar a few days ago.
Read this and check if it helps you.

hockey2112’s picture

hockey2112 commented

Did you ever figure out this mileage calculation? I am doing something very similar in Drupal 7.

karens’s picture

karens commented
Issue summary: View changes
Status: Active » Closed (won't fix)

The D6 version is no longer supported.