Home Forums General Issues Calculating a sum of a number field for all posts Reply To: Calculating a sum of a number field for all posts

  • Hi Laurent,

    I just saw your post about calculating the sum of a number field for a CPT and was wondering if you got it to work and if you could please share the code with me. I am not a programmer and am having a hard time figuring it out.

    My custom post type is ‘investment_project’
    Number field is ‘dashboard_value’

    I need to show the sum of ‘dashboard_value’ through a shortcode in my home page.

    Therefore, my code should look like this?:

    function get_total_investment_value($query_args) {
    $total = 0;
    $posts = get_posts($query_args=’-1′);
    foreach ($posts as $post) {
    $total += get_field(‘dashboard_value’, $post->ID);
    return $total;

    function show_total_investment_value() {
    print get_total_investment_value(array(‘post_type’=>’investment_project’));
    add_shortcode(‘show_the_total_investment_value’, ‘show_total_investment_value’);

    And do I just add this directly as is in the functions.php of my child theme?

    Any help at all will be greatly appreciated!

    Thank you