[Resolved] Is there any way to calculate sum of values of particular field in picked items?

[Author]

Posts

[antonM-7]

Hi!

Please tell, is there any way to calculate sum of values of prticular field in all items, picked by query in Views?

For example, a custom type "Event" has a field "Num-of-visitors", and i want to get a sum of all visitors that took part in all events up to particular date to show this number in summary. Is it possible?

[Christian Cox]

Hi, there's nothing built-in to Toolset that will accomplish this. It requires custom code. In simple cases you can use the following custom code to add up the values of some custom field in a View of posts.

Add to your child theme's functions.php file:

global $total;
function add_total_shortcode($atts, $content = '') {
global $total;
 
$total += wpv_do_shortcode($content);
}
 
add_shortcode('add-to-total', 'add_total_shortcode');

function show_total_shortcode() {
global $total;
$totalNew = $total;
$total = 0;
return $totalNew;
}
 
add_shortcode('show-total', 'show_total_shortcode');

Then in the View's Loop, duplicate the custom field shortcode and wrap it in the shortcode add-to-total, and use the show-total shortcode to display the total value:

<wpv-loop>
    [types field="your-numeric-field" output="raw"][/types]
    [add-to-total]
      [types field="your-numeric-field" output="raw"][/types]
    [/add-to-total]
</wpv-loop>
[show-total]

Note that this is a simple solution that only works in one column of a View, and only works with a simple numeric field. More complex cases will require your own custom code modifications. See also here https://toolset.com/forums/topic/nested-view-with-conditional-sums/

[antonM-7]

Thanks for help, problem is solved! Also have now a clue how to do more interesting things. I'll dig deeper myself, thank you!