Is there any way to create a sum (total) on a report?

  • Profile Image
    webmaster.ncpack825
    Asked on April 26, 2015 at 01:27 PM

    Is there any way to create a sum (total) on a report?  I use JotForm for event registration, and Number Attending is one of my fields, which I'd like to show the running total in an embedded report on my website.  I've looked at all your Report templates, but can't seem to find one with a total calculation option.  I've linked a report to a Google spreadsheet that allows me to calculate the total, but I'd rather have it in the JotForm report itself as not everyone has access to the spreadsheet.

    Thanks...Talisha

  • Profile Image
    raul
    Answered on April 26, 2015 at 01:51 PM

    Unfortunately, that is not possible.

    You could accomplish this with the API by getting all submissions of your form and sum up the values entered in the "Number of Attendees" field to show the results in a web page. But, this would require some knowledge of web programming.

    If you have further questions, please let us know.