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

  • vincelorusso
    Asked on June 7, 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?

  • jonathan
    Replied on June 7, 2015 at 3: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

    How do I get calculations to appear in my Excel download? Image 1 Screenshot 30

     

    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.

    How do I get calculations to appear in my Excel download? Image 2 Screenshot 41

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

    Hope this help. Let us know if issue remains.

    Thanks.