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.