sum of all the valaues of a field of a multivalue field collection [#1333242]

calculating the duration worked out using the computed field
I have requirement to
1.sum up all the durations in a work experience field collection in resume,
help me please pl.
2. Calculate the duration from the oldest start date to Date Now()
have look at screen shot
help please

Comment	File	Size	Author
	resume.png	62.95 KB	kaizerking

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

astanley86 CreditAttribution: astanley86 commented 26 July 2012 at 05:30

Did you figure out how to do this? I am trying to do the exact same thing!

Thanks.

Comment #2

kaizerking CreditAttribution: kaizerking commented 26 July 2012 at 06:11

there is no existing module, and you need to develop a custom module for this, it is really tough job i didn't use computed field module, this module doesn't work with fields 'attached' to field collection fields

Comment #3

astanley86 CreditAttribution: astanley86 commented 26 July 2012 at 06:58

Can you share your custom module? I'm discovering it is more complicated that I'm capable of doing with my limited knowledge of programming.

Comment #4

jlsevillano CreditAttribution: jlsevillano commented 9 January 2014 at 13:38

Did you resolve the problem? I have the same problem :(

Comment #5

david.qdoscc CreditAttribution: david.qdoscc commented 21 January 2016 at 14:42

Issue summary:

View changes

This should work in a computed field to sum field collection values:

$sum = 0;
$wrapper = entity_metadata_wrapper($entity_type, $entity);
foreach($wrapper->field_YOURFIELDCOLLECTION as $collection) {
$sum += $collection->field_YOURSUBFIELD->value();
}
$entity_field[0]['value'] = $sum;