I'm newbie and made web form to fill with some values. I want to sum all values on Column to make it has a total of column Value, like in excel to do sum of several values into one grand total.
Anyone experienced this ?
Thanks in advanced.
Drupal Answers is a question and answer site for Drupal developers and administrators. It only takes a minute to sign up.
Sign up to join this communityI'm newbie and made web form to fill with some values. I want to sum all values on Column to make it has a total of column Value, like in excel to do sum of several values into one grand total.
Anyone experienced this ?
Thanks in advanced.
There is a tab titled "Analysis" for this. Alternatively you can use the "Download" option. See the example in the screenshot below.
You can try Webform Calculator
Provides a formula webform component for computed values, where you can enter a mathematical calculation based on the other fields. E.g., create a formula field with value formkey1 * 0.1 * formkey2.
You can try Webform Calculation Components.
This module provides AJAX functionality to perform basic arithmetic operations on webform components.
With this module the user can have calculated fields, e.g. the total amount, calculated percentage etc.
It works with Webform 7.x-4.x
If you would like to sum the webform submission data, you can use Views Aggregator Plus https://www.drupal.org/project/views_aggregator
You can put sum function in the columns you want to sum. You can put the results in end of the row.