Profile: stephaneB-5

Problem: I have a custom field that stores a number. In a View of posts, I would like to display the custom field and calculate the sum of all custom fields.

Solution: There's nothing built-in to Toolset that will help perform mathematical functions in Views like a spreadsheet. For very simple cases, you can follow these instructions:
Add this code to your child theme's functions.php file, or create a new snippet in Toolset > Settings > Custom code:

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');

Go to Toolset > Settings > Front-end Content and enter show-total and add-to-total separately in the Third Party ShortCodes section.

Use the ShortCodes in a View like this:

<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>
Total: [show-total]