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
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Cookie Policy. If you continue to use this site, you consent to our use of cookies.