Why are Calculation Values not exported to Excel?

  • hripc
    Asked on April 11, 2018 at 3:23 PM

    Why don't the calculated values export into the excel reports?



    1523474606Calcualted Values Screenshot 10

    Jotform Thread 1441830 Screenshot
  • TREVON
    Replied on April 11, 2018 at 3:57 PM

    The reason Calculation values are not exported to excel is because the values are supposed to be used when you want to perform calculations using Calculations Widget or check values when performing a conditional statements

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    Kindly do let us know if you need further assistance.

  • hripc
    Replied on April 11, 2018 at 8:09 PM

    So is there a way to get the values exported in excel? Or are you saying its not possible in excel, only in the widget. 

  • Jan
    Replied on April 11, 2018 at 8:57 PM

    The assigned calculation values can be used only in Form Calculations and in Conditions. You can pass the calculation values in another field if you want. Here's how: How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic.

    Please take note that only the result will appear in the Submissions page or Excel. It is not possible to export the options and the calculated values.

    Thank you for your understanding.