How do I get calculations to appear in my Excel download?

  • Profile Image
    vincelorusso
    Asked on June 07, 2015 at 12:35 PM

    I have 4 calculations set up in my form, at the very end, and they're hidden so that the person filling out the form doesn't see them, but I want to be able to see them in my Excel download. They don't appear and I've made sure the calculations are correct.

     

    Any thoughts?

  • Profile Image
    jonathan
    Answered on June 07, 2015 at 03:10 PM

    Actually when I checked the submission data of the form http://www.jotform.us/form/51177910386156 I noticed that the calculated results were empty.

    user guide: -How-to-view-Submissions

     

    Is the Calculation working properly on the form? Check first also if calculation formula is correct and working. You can try to Unhide first the calculation fields so that you can see in form if they are working.

    If they calculation fields have value they should show up in the submission. 

    If you wanted the empty submissions to still show, you can uncheck the option "Auto Hide Empty Submission" in the view submission page of the form.

    The empty fields will also show up in your Excel download.

    Hope this help. Let us know if issue remains.

    Thanks.