Calculating totals (Daily, weekly, monthly) using drop-down fields in an Input Table field

  • Profile Image
    Asked on April 12, 2019 at 09:12 AM


    I want to create a report that calculates the totals for each drop down by station daily, weekly and monthly.  

    Is this possible?

  • Profile Image
    Answered on April 12, 2019 at 12:19 PM

    I would like to apologize for any inconvenience. I understand you have specific choices that you would like to have as options of the drop-down fields of the Input Table field in your form. However, the calculation works only if the options in the drop-down fields in an Input Table fields are numbers. Then, to get the total, you can use a Form Calculation widget — How-to-Perform-Form-Calculation-in-the-Matrix-Field

    Please note that the Calculation Values option of the Input Table field must be empty for that to work.

    Also, if possible, may I suggest that you change the options to numbers and include a Legend Table using the Text element that would explain what the numbers are equivalent to?

    If you have other questions or concerns, please do not hesitate to let us know.