Perform calculations in Form reports

  • Profile Image
    Dunaz99
    Asked on June 20, 2020 at 03:07 PM

    Is it possible to perform calculations on the data users enter and then create a custom report for them showing the results of those calculations?

  • Profile Image
    JohnRex
    Answered on June 20, 2020 at 04:54 PM

    If you mean you would like to add calculations into the FORM REPORTS, unfortunately, this is not possible at the moment. Note that only the actual alpha values are available for reports.

    So if there's a calculation needed, you can do it into the form itself by using FORM CALCULATION widgets. Just hide it into the form so your users won't be able to see it.

    You can then add the generated value of that widget when creating the report.

    Here's a guide on How-to-Perform-Form-Calculation-Using-a-Widget.