I am asking my view to calculate one column. There are three columns in the view: node title, node start date (cck date field), and number of people. The number of people column is the calculated column and I'm asking the view to sum the values.
All the pertinent modules are the current version and are release candidates as of Jan 21/2009 (and not dev).
So when I load the view the page loads but the bottom line of the table is not a totaled row, as I expect, but rather has a node title, no date, and an erroneous total... png attached.
Thanks!
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | VIEWCALCEXAMPLE.png | 27.57 KB | Toddv |
| #2 | viewsexpt.txt | 2.5 KB | Toddv |
| #1 | viewcalc.png | 96.78 KB | Toddv |
| screenshot.png | 50.47 KB | Toddv | |
| viewexport.txt | 6.46 KB | Toddv |
Comments
Comment #1
Toddv commentedUpdate: tried it all again w/ both dev and rc versions, starting by building a fresh views table, confirming it worked as expected, then converted to views calc table: no calculations; all my other modules are release versions and are up to date.
The view I'm trying to calculate has several exposed filters and multiple columns, per attached png.
Still no column totals at all in my view. So, any help appreciated.
PS: our old D5 site used views_calc for D5 extensively with great results.
Thank you,
Comment #2
Toddv commentedTo elaborate:
I have two live sites using D6, Views, Calendar/Date, cck, views calc (et al); all current rc or release versions as of Jan 31, 2009. I've tried different themes (using Acquia as default but also tried Garland).
Caches have been emptied.
I can't make views calc calculate.
I have created a simple table to test this, at both sites, as follows:
1. create content text field "program length" and date field for start and end date.
2. create content type = "event", attach "program length" to it.
3. create event #1 with a title and a program length of 5
4. create event #2 with a title a a program length of 5
4.a etc - create a few other test events
5. Build view table, displaying fields "node title" and content: program length, and with filters node: type and date: date (event start date)
6. Table works as expected
7. Convert style to Views Calc Table, with my column "field length" set to "sum", "display calculation" is checked,
8. Now I get a similar table but the top row is the title of the bottom row, where I would expect the calculation results to appear. And no sum. Any help appreciated.
Thanks again,
TV
Comment #3
Toddv commentedIn case it is helpful to anyone:
Newbie error: I had old modules (Calendar, Date, Views_calc) named w/ prefix "old" to, I thought, disable them. But just adding an "old" in front of the the module name doesn't necessarily disable it, as I have learned...
This stuff is voodoo as far as I can tell but here's what I did:
So, once I discovered that I just deleted all the old and current modules related to views_calc and my view. In my case all versions of calendar, date, views_calc, and views. Re-installed fresh ones incl views_calc 6.x-1.0-DEV (instead of rc so an imperfect control, maybe the dev vs rc was causing the problem).
Ran update php.
I found my existing views_calc views still didn't calculate. I tried re-saving those views but they still didn't work.
So I built a new view w/ views_calc as the style. It worked. I may still be having an issue when filters are exposed but that's another issue.