Views Calc

Turn a normal table like:

into this:

Instructions:

Create a view and add fields to it as you normally would. Start by creating a normal table and make sure that works as you expect.
Change the style type from 'table' to 'Views Calc table'.
In the Views Calc table settings, mark which fields need calculations.
Save the view.

Comments

Field...

sherabdorje commented 30 April 2009 at 14:55

What may I do to have fields like the examples:
Content: Date
Content: Rank
etc.

I've tried to add a kind of field "content" but i didn't find it ¿?
It may be obvious but i don't know how to do it.

Show details

mylesorme commented 3 May 2009 at 00:02

I assume by content you mean the body of the post...

The style options include the tick box "show details"

Totals by group

mylesorme commented 2 May 2009 at 23:55

How do we create sub-totals by group

Lets say we have a table showing: school; number of volunteers

This is grouped by 'programme'

How do I get a sub-total for each programme - at the moment it just repeats the totals at the end of each group?

Great Question...

MrAdamJohn commented 18 June 2009 at 16:31

Wondering the same thing ..
Looking into going about an approach here: admin/settings/views_calc

Any progress on your end mylesorme? (or anyone else?)

warning: Invalid argument supplied for foreach()

kk-mini-pw commented 23 May 2009 at 13:45

Hi I have a table with several fields and grouping option. When I switch to Views Calc Table I get:
warning: Invalid argument supplied for foreach() in .....sites/all/modules/views_calc/theme.inc on line 178.

Is there any patch for this?
Thanks,
K.

Similar - seems specific to Date fields

SiteMaster.ServeLime.com commented 14 August 2009 at 06:31

Hi there.

I seem to get a similar error - when using a Date field. (might be Date-specific ?)

Echo that

Anonymous (not verified) commented 28 August 2009 at 07:00

I get the same error. I think I had enabled a relationship in one view and later took it out but the error remains.

Same thing for me...

shaynl commented 3 September 2009 at 13:40

"warning: Invalid argument supplied for foreach()"…
Is it working with computed fields?

foreach() error

MikeBC commented 15 September 2009 at 01:01

it went away for me once I created a calculated field in the view

Row titles?

fishfilet commented 13 December 2009 at 22:05

In your example it shows a title for the calculated row like Count: 6 or Max: 15 How do I get this when I am calculating a row all I get is the value?

Balance sheet

chrispane8 commented 26 December 2009 at 22:43

Hi,

is it possible to create a balance sheet with views calc; subtracting expenses from income?

Chris

subtracting one sum from another sum

willemt commented 17 March 2010 at 15:29

I would need the same thing: Calculate the sum of one column=A, calculate the sum of another column=B and have a "grand total" (C=A-B) displayed. Possible?

multiple pages view

willemt commented 17 March 2010 at 15:35

How does this work when the view is configured to be displayed in several pages (as in maximum 10 entries displayed per page but there's over 100 entries alltogether)? Will the calculations be based on all 100+ entries or only those 10 entries displayed at that time?

Example for calculation field?

Durrok commented 9 July 2010 at 20:22

As seen at: admin/settings/views_calc

Anyone have an example of what can go in the calculation field?

Same for the custom function.

Block Display

kevinkpierce commented 19 July 2010 at 17:34

Is it possible to display calc results in a block? e.g. without the items being added being shown? For example, Projects are buildings that save energy. I can make a table showing total savings, but can I make a block to display only the total?

Block Display

pvanerk commented 6 June 2011 at 17:03

@kevinkpierce: Hi, any luck on creating a total in a block display. I am more or less looking for the same but then in combination with the option to select certain nodes in a view and get a total from that.

You have to uncheck "show

chrispane8 commented 5 July 2011 at 13:22

You have to uncheck "show details" (don't remember if it's the exact phrase.

Chris
http://www.neuros.fr

Draggable Views in Views Calc table

slcmayor commented 24 June 2015 at 06:43

Hi all, does anybody know if it's possible to use Draggable Views in a Views Calc table? I have a 'drag to change order' feature on a standard views table, but really want to use this module to sum one column in the same table. When I tried this, the drag crosshair icon disappeared, and I got an SQL left join error. Thank you.