Why are Calculation Values not exported to Excel?

  • Profile Image
    hripc
    Asked on April 11, 2018 at 03:23 PM

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



    1523474606Calcualted Values.png

  • Profile Image
    TREVON
    Answered on April 11, 2018 at 03: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.

  • Profile Image
    hripc
    Answered on April 11, 2018 at 08: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. 

  • Profile Image
    Jan
    Answered on April 11, 2018 at 08: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.