Getting the Calculation widget to calculate for report builder

  • Profile Image
    exceltraining38
    Asked on December 11, 2020 at 07:57 PM

    Getting the Calculation widget to calculate for report builder.


  • Profile Image
    Ahmed_S
    Answered on December 12, 2020 at 12:15 AM

    Hello exceltraining38,

    Unfortunately calculations by widget or conditions are only available for forms not reports, if you want to do calculations on a report you can create an Excel report out of your form and then do any required calculations in the sheet, Please check this guide to how create Excel report: https://www.jotform.com/help/101-how-to-create-an-excel-report.

    You also still able to get calculations in your form in an alternative way by doing the calculation in the form itself and make the field with the calculated values hidden, this way you will find the calculated value ready in your report, in other words instead of doing the calculations in the report, do it in the form with calculation widget or condition so you can get it in the report as any other fields of the form.

    1607750004_5fd45174105dd_screen.gif

    Please let us know if any of these suggestions works for you and if you need any further assistance, we will be happy to help.