Elastic Report Excel Issue Forum Home › Forums › Runtime Bugs › Elastic Report Excel Issue This topic contains 1 reply, has 2 voices, and was last updated by Mikhail 7 months ago. Viewing 2 posts - 1 through 2 (of 2 total) Author Posts October 25, 2018 at 2:03 pm #4495 AAllabyParticipant Hi I am having an issue with exporting a report to excel, in my columns I have it calculate the average of the entire column at the bottom of the sheet. Although the range used in the calculation is one row off which gives an incorrect average. <Column name=”Column 1″ cnlNum=”1″ calcType=”Val” calcAvg=”True” /> If I export to a PDF it works fine, or if I add the calcTotal function it works in excel, although I do not want the total value there. Any ideas? Thank you. October 25, 2018 at 6:27 pm #4498 MikhailModerator Hi, Could you provide a screenshot of the Excel and PDF reports where the difference is visible? Author Posts Viewing 2 posts - 1 through 2 (of 2 total) You must be logged in to reply to this topic.