Is there anyway to replicate an excel table with a sum calculation ?

  • Profile Image
    Kryinix
    Asked on February 28, 2018 at 04:43 AM

    Hi,


    i just had a quick question to see if there is any widget or a way that a can do a summary of column with multiple rows ( like excels auto sum / sum function ) that will then auto fill a box with a total , the closest i have found to use is the matrix dynamic but there isn't a way to sum the total entered within a column,

    I am trying to replicate the screenshot attached,


    Thank you,


    RSG

  • Profile Image
    Kevin_G
    Answered on February 28, 2018 at 09:34 AM

    It's not possible to perform calculations with widgets, but you may use an input table to perform calculations: 

    15198284151.png

    This guide will help you performing calculations based on this table: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    Please note that the input table element can have different field types that can be changed on the settings section of the field, but it's not possible to have a mix of all the fields.